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!
Tom_Y
Advocate II
Advocate IIFor anyone who has been struggling for days/ hours, this is my solution to my problem, the "All" is working, but you need to plan if you want to put it first, or you want to it after your filter in calculation.
Mine is that I need to calculate based on specific year filter (e.g. 4 years average in 2020-2024), but then I can't let it influenced by filter in Matrix.
Household_FY_20/24 =
Household_FY_20/24 =
DIVIDE(
CALCULATE(
DISTINCTCOUNT('Project_Table'[ClientID]),
'Date_Table'[FY] IN {"FY20/21", "FY21/22", "FY22/23", "FY23/24"},
ALL('Date_Table'[FY])
),
4
)