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

Hi,

 

Not sure if this is what you are looking for, but if you select a slicer and then go to the format menu and click "edit interactions" you can turn off a visual you don't want to be filtered by that slicer

 

Thanks,

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Yup, I figured it out.

 

I also created a measure to do the same for another dashboard.

 

Thanks for responding though. Power BI community is great !!

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Would you please let me know how did you resolve this I am facing similar issue. TIA