Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I believe there is a bug in Power BI Desktop (tested in May 2017) with the ALL function.
Here is the scenario (using Adventure Works)
I place Calendar[Day Name] on rows on a visual.
I write a measure [Total Sales]
I write the following measure to return all the sales for all days.
Total All Day sales = CALCULATE([Total sales],all('Calendar'[DayName]))
The above measure works as long as I have not used "sort by column" in the calendar table. If the column Calendar[DayName] uses the native sort, then the above measure works. If I change the default sort column to Calendar[DayNumberOfWeek]) then the above measure does not work.
If I write the following measure then it does work
Total All Day sales = CALCULATE([Total sales],all('Calendar'[DayName]),all('Calendar'[DayNumberOfWeek]))
But the addition of Calendar[DayNumberOfWeek] should not be needed inside the ALL function
Here is a sample workbook to demonstrate the problem. https://www.dropbox.com/sh/ulfwt1eo6dfxf3b/AACGQF6zt7y2WvuZUbLkcVL8a?dl=1
Please confirm if you agree this is a bug.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.