Forum Discussion
Make measure ignore specific filter
This should be simple but I just can’t solve it :) I have a report page with several filters and a measure Amounts = SUM(Table.Amount). Now I’d like Amounts to ignore just one of the filters, a Page...
This is not really an issue. It is clearly explained in this article from Alberto. It is happening because of Auto Exist feature in DAX.
Besides, creating a seperate dimension table is not really a workaround, but rather a best practice. A Star Schema is always considered best when working with Power BI Datamodel. This is what makes it more powerful!
I have the same problem - trying to calculate the Fiscal Budget for a year and need to ignore the month filter ( YYYY,MM are the filters). Why can't Microsoft make is easy like Tableau for standard time functions ?
Thanks, Greg the solution you proposed works. Really counterintuitive if I have to define the measure on the Date dimension table.
For now it works and that's all I care about