Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
I am trying to create a measure that will be affected by a slicer that is selected.
I have two measures that need to be affected by different slicer filters on one page, hence why I am not just synching all of these filters to this page.
I need to dynamically filter this measure in a dax expression.
My fact table is called 'public failure' and the dim table that the slicer is based on is 'public consumableVersion' which has a relationship to a table called 'public consumable' that has the relationship to 'public failure' through the consumable id.
I currently have this:
Solved! Go to Solution.
For the measure which needs to ignore 2 of the slicers you can use REMOVEFILTERS to ignore filters on the particular table or column used in the slicers.
Slicers only affect the page that they are on. If you need a slicer to affect multiple pages you will need to duplicate the slicer on each page, make sure that it is set to sync. You can set it to hidden so that it doesn't affect the pages visually.
Once you have that set up, I don't think you would need the FILTER function in your code.
That is what I was doing before. However, I have two measures that need to be used in a visual. One of which needs to be affected by 6 of the 8 slicers I have. The other measure needs to be affected by all 8 slicers. Does that make more sense?
For the measure which needs to ignore 2 of the slicers you can use REMOVEFILTERS to ignore filters on the particular table or column used in the slicers.
Thank you this works for me!
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
92 | |
83 | |
71 | |
49 |
User | Count |
---|---|
143 | |
120 | |
110 | |
59 | |
57 |