## Search found 12 matches

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...
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...
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...
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.
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...
Sat May 19, 2018 2:46 pm
Forum: Help with the Book "Learn to Write DAX"
Replies: 2
Views: 300

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 ...
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...
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...
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 ...
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...