Forum Discussion
Visual
Hi Mon_0Pun,
You need to use the measure in your visual and not as slicer or visual filter. If you are using sematic model or a live connection you should still be able to create a table n top of it.
I've created a sample .pbix file showcasing the page level filter, Edit interaction and Visual level filter without creating a new table. hope this clarifies how you cn inplement the same.
Hi Mon_0Pun,
There are few ways to achieve this:-
1. You can ignore filters for a particular measure using removefilters, for e.g.
Total Sales (Ignore Page Filters) =
CALCULATE(
SUM(Sales[Amount]),
REMOVEFILTERS()
)
2. You can create a disconnected table for the fields like SlicerTable = DISTINCT('Sales'[Category])
and then use it in your final DAX like
Selected Sales =
CALCULATE(
SUM(Sales[Amount]),
TREATAS(VALUES(SlicerTable[Category]), Sales[Category])
)
3. You can use edit interaction to stop slics to interact with that particular visual, to do that go to Format → Edit Interactions and then turn off the interaction
🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
🔗 Curious to explore more? [Discover here].
Let’s keep building smarter solutions together!
Thanks grazitti_sapna for the providing the solution. I used your remove filter measure, but I am unable to use that measure in my filter visual. Also my access is restricted to create any table or column.
Hi Mon_0Pun,
You need to use the measure in your visual and not as slicer or visual filter. If you are using sematic model or a live connection you should still be able to create a table n top of it.
I've created a sample .pbix file showcasing the page level filter, Edit interaction and Visual level filter without creating a new table. hope this clarifies how you cn inplement the same.