Table and Card only showing data if one value is available (not multiple)

[dellmech]

Hi, I'm trying to have the value in a Table and Card ONLY show up when there is only 1 possible value to go there.  If there are multiple values, I want it to be blank or return a message ("N/A")

For example: If I choose a country, it may have 4 requirements.  This will show 4 details but I don't want details to show multiple values or the card with the date to show the first or last value of the 4.  I want these visuals to show the value once a requirement is selected.

I know you can do a COUNTROWS function but I didn't know if you can somehow utilize that to show data in that Details table and Date card when rows = 1.  

Any help would be appreciated!

[ryan_mayu · Accepted solution]

@dellmech 

you can try to create a measure

Measure = if(DISTINCTCOUNT('Table'[Details])>1,"N/A",max('Table'[Details]))

and do the same for date card.

pls see the attachment below

[ryan_mayu · Accepted solution]

@dellmech 

you can try to create a measure

Measure = if(DISTINCTCOUNT('Table'[Details])>1,"N/A",max('Table'[Details]))

and do the same for date card.

pls see the attachment below

[dellmech]

This worked for the details table except the date.  It is returning "N/A" when there are multiple values like I wanted.  However, when there is a single value found...instead of the date showing...it is showing #,0.00

Any idea how to fix this?

[ryan_mayu · Accepted solution]

@dellmech 

you can try this

Measure 2 = if(DISTINCTCOUNT('Table'[date])>1,"N/A",FORMAT(max('Table'[date]),"yyyy/mm/dd"))

pls see the attachment below

[dellmech]

Thank you SO much!

[ryan_mayu]

you are welcome