Forum Discussion
Solved
How to remove slicer filter when Sumx distinct count
I have a measure that needs to show both the distinct count and the sum of distinct counts on the total line. I can create this measure in different ways, and both approaches work. However, we a...
Good suggestion, I add new table and create relationship, but still not works
johnt75
Super User
Super UserAre all the columns on the same table ? If so this might be a case where auto exists is causing a problem.
If they are all on the same table, create a separate table like
Ticket Type =
DISTINCT ( CX_Scorecard[Ticket Type] )
and create a one-to-many relationship from the new table to CX_Scorecard. Use the new table in your slicer, and any other visuals, and change the measure code to REMOVEFILTERS from the new table rather than CX_Scorecard.
Thank you very much, this measure works after I remove other filter on report level.