Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello everyone. I have some monthly cards I made for to quickly see current situation for a use case. They work untill I use a slicer till I use date slicers/filters which is logical. So I want them to ignore any filters I use on my visuals I guess to work with FILTER() and ALL() but I can't figure it out. I have following cards:
MonthVariance =
Solved! Go to Solution.
You can switch off interactions
And have visual level filter on date.
You can switch off interactions
And have visual level filter on date.
Cool, this worked! But it should also be doable with DAX-code right?
Hi,
To remove all filters from a table you can add in your formula :
ALL(fact_harvest_time)
ALL functions accept a table or a specific column from a table as argument, so to remove from all columns just use the table name as argument in your all function.
so It will make something like :
=CALCULATE([yourmeasure],ALL(fact_harvest_time);...rest of calculation)
Let us know if it works,
Hey @AilleryO I tried this but didn't seem to work:
Hi @Anonymous ,
Is your slicer based on this table : fact_harvest_time ?
Yep!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |