Visual Data to ignore the Filter

[Anonymous]

Team

Question : I have 4 drop down filter and one visual 

User will select only 4th filter and based on that Filter one will populate automatically and filter 4 will be ignored, visual will show all data for the filter 1 which is not yet slected by user ..

let me  know if this is possible 

thanks

[v-cazheng-msft · Accepted solution]

Hi @Anonymous 

You can create a disconnected table with the values in the fourth Slicer. Then create a Measure as the following.

DataExceptSelected =

VAR val =

    FILTER ( GroupTable, ALLSELECTED ( GroupTable[Group] ) )

RETURN

    CALCULATE (

        SUM ( 'Table'[Amount] ),

        FILTER ( 'Table', NOT 'Table'[Group] IN val )

)

The result looks like this:

For more details, you can refer the attached pbix file.

Best Regards

Caiyun Zheng

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.