Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

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...
Need Help
  • AkhilAshok's avatar
    AkhilAshok
    7 years ago

    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!

     

     

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hey, I had a similar situation that I found a solution to. I needed the sum of Table1.Amount, but ignoring any filters on Table1.Filter. I tried "Calculate( Sum( Table1.Amount) , All(Table1.Filter))" but this did not work. It didn't work because even though Table1.Filter was not being directly filtered, it was being crossfiltered by Table2.Filter. To ignore the crossfilter, I tried this and it worked:

 

Calculate( Sum( Table1.Amount) , All(Table1.Filter), All(Table2.Filter)  )

EP's avatar
EP
New Member
6 years ago

Thank you Anonymous!! Solved my problem perfectly!