how do I bring a column in to a visual without it being filtered by the slicer?

[Anonymous]

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!

[Anonymous · Accepted solution]

Hi @Anonymous

Try this:

Dist with ALL Meas = CALCULATE(DISTINCTCOUNT(Table1[Country]),ALL(Table1))

Thanks
Raj