Display NA in card visual when no values from slicer are selected

[NKotak_Leecare]

How to display NA in the card visual when no values are selected from the slicer visual?

Here is the snapshot of the slicer and the card visual where card visual needs to be NA when nothing is selected from the slicer visual. When a value is selected from the slicer visual, the card values displays the count of that value. So, when nothing is selected, it needs to display NA.

Appreciate your time and support in advance :))

Cheers!

[TheoC · Accepted solution]

@NKotak_Leecare 

You can use the following measure to achieve what you're after:

MEASURE = IF ( ISFILTERED ( Table[Column] ) , SELECTEDVALUE ( Table[Column] ) , "NA" )

Output of unselected is:

Example of a selected value is:

Hope this helps 🙂

Theo

[TheoC · Accepted solution]

@NKotak_Leecare 

You can use the following measure to achieve what you're after:

MEASURE = IF ( ISFILTERED ( Table[Column] ) , SELECTEDVALUE ( Table[Column] ) , "NA" )

Output of unselected is:

Example of a selected value is:

Hope this helps 🙂

Theo

[NKotak_Leecare]

Thank you Theo!

I have tried using this measure but I am getting the Form ID rather than the count of it.

MEASURE = IF ( ISFILTERED ( 'ltcdb_test ltcschema'[ReportCaption] ) , SELECTEDVALUE ( 'ltcdb_test ltcschema'[FormID] ) , "NA" )

Output: 

The count of form via card visual is 1 whereas using Measure it is showing 1401. 1401 is actually the ID of that form and not the count. Can you please let me know how can I display the count with this meassure?

[NKotak_Leecare · Accepted solution]

Hi Theo,

It worked out. I just changed the selectedvalue to count and i got both the things i wanted.

MEASURE = IF ( ISFILTERED ( 'ltcdb_test ltcschema'[ReportCaption] ) , COUNT( 'ltcdb_test ltcschema'[FormID] ) , "NA" )

Thank you heaps for your time and support.

Cheers!

[TheoC]

@NKotak_Leecare sincere apologies!  I only saw your comment after you send the most recent one!  Apologies but well done on getting a solution!

[NKotak_Leecare]

All good, Theo! Thank you for helping me out with the main formula :))