Forum Discussion
Sonam_Pillai
6 years agoHelper I
How to exclude values
I have data like this: Cities Criteria Value Mumbai Criteria1 376 Mumbai Criteria2 null Chennai Criteria1 471 Chennai Criteria2 254 Delhi Criteria1 null D...
Anonymous
6 years agoNot applicable
Hi Sonam_Pillai,
The best simple way is to use 'Criteria' field on your 'visual level filter' with advanced filter mode 'not' option and type the values which you do not want to be displayed.
In addition, you can create a calculate table to extract the Criteria field values without relationship mapping and use it to create a slicer, then write a measure to filter records based on selection and use on raw chart visual level filter to filter records.
Calculate table:
Selector =
VALUES ( Table[Criteria] )
Measure filter formula:
measure =
VAR selected =
ALLSELECTED ( Selector[Criteria] )
RETURN
IF (
COUNTROWS (
FILTER ( ALLSELECTED ( Table ), [Criteria] IN selected && [Value] <> null )
) > 0,
"Y",
"N"
)
Regards,
Xiaoxin Sheng