Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
How can I create a measure that shows percentage of data (with several page level filters e.g. multiple slicers on my page) against the same data set minus 2 filters?
E.g filteredData / (filteredDataWithoutX&Yfilter)
I've tried the ALL function but that unfortunately removes all the filters and I only want to remove some of the filters not return the entire unfiltered data set. I've also tried the KEEPFILTERS function but I cannot get this to work at all.
Solved! Go to Solution.
In this scenari, since you want to remove all other filters but keep some filters, you should use ALLEXCEPT() to keep expected filters in you CALCULATE() function.
Regards,
In this scenari, since you want to remove all other filters but keep some filters, you should use ALLEXCEPT() to keep expected filters in you CALCULATE() function.
Regards,
Hi @HelpAccount
You can probably build a measure were you ca hardcode the names of these filters to ignore. If you provide a small sample of data we might be able to help.
Cheers,
Phil
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!