hatahetahmad
New Member
- Joined
- Jan 8, 2016
- Messages
- 31
Hello MrExcel members.
I made a cumulative measure using calculate, all calendar and max date, very easy basic DAX.
When I drill through from page to page in Power BI desktop report this cumulative measure doesn't work, more specific All Calendar doesn't work, because I tried using All Data and it works (it gives me the sum of all rows in the table).
The source report has month and year filters, which the target report inherits from the source.
My point of view is the Calendar table filter the Data table because of the relationship,
and the Cumulative function has ALL(Calendar[Date]) filter but the drill through overwrite the filter inside calculate.
Is this what happening?
How to solve this?
And Is it a matter on how Power BI prioritize the filters?
I made a cumulative measure using calculate, all calendar and max date, very easy basic DAX.
When I drill through from page to page in Power BI desktop report this cumulative measure doesn't work, more specific All Calendar doesn't work, because I tried using All Data and it works (it gives me the sum of all rows in the table).
The source report has month and year filters, which the target report inherits from the source.
My point of view is the Calendar table filter the Data table because of the relationship,
and the Cumulative function has ALL(Calendar[Date]) filter but the drill through overwrite the filter inside calculate.
Is this what happening?
How to solve this?
And Is it a matter on how Power BI prioritize the filters?
