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,
Does anyone know the dax formula to create a new measure that says count distinct but ignore the filter thats being used on the page?
I am trying to show:
the count distinct of orders for the general population
vs
the count distinct of orders for type of order selected in the slicer
I am using the visual line and clustered column chart where I want the count distinct orders both next to each other under column values. I just need to know the formula to place on the duplicated order column that ignores the slicers!
Solved! Go to Solution.
Hi @Anonymous
Try this:
Dist with ALL Meas = CALCULATE(DISTINCTCOUNT(Table1[Country]),ALL(Table1))
Thanks
Raj
Hi @Anonymous
Try this:
Dist with ALL Meas = CALCULATE(DISTINCTCOUNT(Table1[Country]),ALL(Table1))
Thanks
Raj
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 |
---|---|
114 | |
101 | |
78 | |
75 | |
49 |
User | Count |
---|---|
145 | |
108 | |
107 | |
89 | |
61 |