Forum Discussion
Measure to Ignore Slicer Selection
Hi,
See below image: The table is showing correct "DT National"
However, if I select a zone, for example Adelaide, the "DT National" is now filtered to Adelaide too.
This is the current formula of "DT National"
Hi Anonymous
This has nothing to do with measure, even if you don't put any value the visual will be filtered (see below).
So in this scenario, you can change the interaction control, link: Change how visuals interact in a report - Power BI | Microsoft Docs
result
Or you can create a table below and use it in slicer, but it needs you to change your measures accordingly.
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
7 Replies
v-xiaotangCommunity Support
Hi Anonymous
This has nothing to do with measure, even if you don't put any value the visual will be filtered (see below).
So in this scenario, you can change the interaction control, link: Change how visuals interact in a report - Power BI | Microsoft Docs
result
Or you can create a table below and use it in slicer, but it needs you to change your measures accordingly.
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
v-xiaotang Thank you.
Creating a separate table for the Zone works.
- amitchandak
Super User
Anonymous , Try like
DT National = CALCULATE([DT],ALL('Delivery Jobs Table'))
DT National = CALCULATE([DT],removefilters('Delivery Jobs Table'[Zone Name]))
The first suggestion seems to break the date in the table:
The second suggesion is having the same issue as before:
- amitchandak
Anonymous ,
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
VahidDM You helped me a lot in the past.
Just wondering if you have any insights on this?
