topic Re: If not filter, show value table with condition in DAX Commands and Tips

If not filter, show value table with condition

thaonguyen — Tue, 13 Sep 2022 10:14:50 GMT

Hi all,

I have a problem about slicer and table list.

I have an example table:

I have a slicer BU. When I don't filter any slicers, I want the table only shows records that have NOTE = off/ null.

If I filter BU, the table will show all NOTE.

Please help me with it,

Thanks so much.

tamerj1 — Wed, 14 Sep 2022 04:00:33 GMT

Please follow attached sample file for the solution

Filter Measure = IF ( ISFILTERED ( 'BU Selection'[BU] ), 1, COUNTROWS ( FILTER ( Data, Data[NOTE] IN { "off", BLANK ( ) } ) ) )

thaonguyen — Wed, 14 Sep 2022 03:09:41 GMT

I really got it. Thank you so much for your comment

tamerj1 — Wed, 14 Sep 2022 04:01:58 GMT

thaonguyen
I notice a small mistake in the code. Please refer to the updated one in the "Marked as accepted solution" reply.