Search found 12 matches

by RamanaV
Fri Aug 03, 2018 2:56 pm
Forum: Help with the Book "Learn to Write DAX"
Topic: Sales of Bikes to Married Men - CALCULATE()
Replies: 2
Views: 118

Re: Sales of Bikes to Married Men - CALCULATE()

Hi, The Measure has a CALCULATE that filters Products table for Category "Bikes" and Customers table for MaritalStatus "M". And whatever result you got $14,602,515 is for total sales of bikes for married men. Now coming to your two pivot tables - The first one results are ok - be...
by RamanaV
Wed Aug 01, 2018 1:34 pm
Forum: Help with the Book "Learn to Write DAX"
Topic: Ch19 Multiple Data Tables missing data
Replies: 2
Views: 96

Re: Ch19 Multiple Data Tables missing data

Hi, You need to get the tables once again from AdventureWorks database. Look at the section - Here’s How: Adding a Budget Table. It has step-by-step instructions to do the same. Once you load the tables, you will see those tables also in the data model. Hope this helps you in proceeding with Chapter...
by RamanaV
Sat Jun 02, 2018 9:12 am
Forum: PowerPivot/DAX
Topic: [URGENT] how to multiply different columns with a dax measure
Replies: 1
Views: 278

Re: [URGENT] how to multiply different columns with a dax measure

Hi, The major difference between Excel and Power Pivot (DAX) is * In Excel you can refer to a cell (A1, B2, AC2, etc.) and you can refer to a range of cells (E2:E200). * But in DAX you need to think differently. You can refer to an entire column in the table or the entire table. You can read Matt Al...
by RamanaV
Tue May 22, 2018 3:09 pm
Forum: PowerPivot/DAX
Topic: PowerBi Matrix Subtotal Feature & Measures
Replies: 2
Views: 297

Re: PowerBi Matrix Subtotal Feature & Measures

Hi,

How did you define all the measures? I did not look at the dropbox .pbix file.

In DATESBETWEEN function, [Month till where data is available] is used twice. How come?

If you can clarify this, I will look at the output and try to answer your question.
by RamanaV
Tue May 22, 2018 2:47 pm
Forum: Help with the Book "Learn to Write DAX"
Topic: 5: Concept: Filter Propagation [Solved]
Replies: 2
Views: 693

Re: 5: Concept: Filter Propagation [Solved]

Hi, First, a clarification on COUNTROWS and DISTINCTCOUNT: * COUNTROWS returns the total number of rows in the table. So, your number of customers is the total number of rows in the Customers table. * DISTINCTCOUNT returns the number of distinct (unique) values in the column in the table. So, your f...
by RamanaV
Sat May 19, 2018 2:46 pm
Forum: Help with the Book "Learn to Write DAX"
Topic: Questions around 2: Concept: Loading Data [Solved]
Replies: 2
Views: 300

Re: Questions around 2: Concept: Loading Data [Solved]

Hi, Here are some clarifications: 1. In the data model you will have lookup tables (dim tables) and data tables (fact tables). In the sample AdventureWorks database, the tables are cleaned and shaped for a direct load into your data model. However, it may not be the case when you get data from else ...
by RamanaV
Wed May 16, 2018 9:11 am
Forum: PowerPivot/DAX
Topic: Pivot Table output help [Solved]
Replies: 2
Views: 422

Re: Pivot Table output help [Solved]

You need to first load your table into Data Model. - Click on Power Pivot tab, and then on Add to Data Model. Next, write 3 measures. To write a measure, click on Power Pivot tab, and then on Measures, and then on New Measure. Total Premium = SUM(DataTable[Premium]) Total Losses = SUM(DataTable[Loss...
by RamanaV
Tue Apr 24, 2018 11:34 am
Forum: PowerPivot/DAX
Topic: #1 Complex Powerpivot requirement
Replies: 2
Views: 381

Re: #1 Complex Powerpivot requirement

Yes, I agree that you came to the right forum for your queries on power pivot or power bi. And, most importantly, you can learn power pivot only by learning how to write DAX formulas. I suggest you attend Matt Allington's online training "Supercharge Power BI", wherein he explains how to w...
by RamanaV
Sun Apr 22, 2018 8:28 pm
Forum: Power BI Desktop/Service
Topic: Best approach to building a data warehouse?
Replies: 1
Views: 294

Re: Best approach to building a data warehouse?

In Power BI, it is possible to connect to different data sources, combine the data, shape the data, do the data modelling, analysis and reporting. Note that in Power BI, there will be only one data model. The data model will have lookup tables and data tables. The best way to organize data in Power ...
by RamanaV
Thu Apr 19, 2018 1:34 pm
Forum: Help with the Book "Supercharge Power BI"
Topic: #47, #49 Using Customer vs. Sales table
Replies: 2
Views: 458

Re: #47, #49 Using Customer vs. Sales table

If you have a filter applied in your Matrix, say on Occupation (this is called Initial Filter Context), your formula returns same values as that of [Total Sales] by Occupation. The eBook formula, on the other hand, overrides the Initial Filter Context (using ALL over the Customers table), and return...

Go to advanced search