## Search found 14 matches

Wed Oct 17, 2018 10:27 am
Forum: PowerPivot/DAX
Topic: DAX Formula - Follow Filter Context Except...
Replies: 2
Views: 57

### Re: DAX Formula - Follow Filter Context Except...

Hi,

What is the Measure you have? Assuming that it is [Total Sales], you can try the following:

Total Sales for all Customers = CALCULATE([Total Sales], ALL(Customers))

Ramana
Wed Oct 17, 2018 9:31 am
Forum: Power BI Desktop/Service
Topic: Not able to IMPORT CALCULATED Measures into POWER BI from Excel Sheet
Replies: 2
Views: 61

### Re: Not able to IMPORT CALCULATED Measures into POWER BI from Excel Sheet

Hi, Few quick observations. 1. Both in Excel and Power BI you have "Measures". Only in Excel 2013 version "Measures" were renamed as "Calculated Fields". So there is nothing called CALCULATED Measures. 2. Excel file size is 34 MB. Excel file only with a data model canno...
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: 337

### 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: 4
Views: 911

### 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: 461

### 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: 491

### 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: 998

### 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: 548

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: 619

### 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: 543

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