Card change on filter

[nataliesmiy1357]

Good morning!  I have a page with a bunch of cards on it.  The cards are bringing in a measure called No Read Perc

No Read Perc = 1 - DIVIDE([No Read Count], [Total Number of Pallets],0)

When I filter the page, if there is no data for those cards, it's bringing the value in as 100%.... I am looking to see if I can make that default a "No Data".

Ex below) I have a filter on RFID 16, so all of the other cards should read "No Data" instead of 100%. 

Thanks in advance for your help

[dharmendars007 · Accepted solution]

Hello @nataliesmiy1357 , 

Adjusted Measure for "No Read Perc" like below

No Read Perc =
IF (ISBLANK([No Read Count]) || ISBLANK([Total Number of Pallets]),
BLANK(),
1 - DIVIDE([No Read Count], [Total Number of Pallets], 0))

Alternatively, you can try out the below measure as well to use text "No Data" in card.

No Read Perc =
IF (ISBLANK([No Read Count]) || ISBLANK([Total Number of Pallets]),
"No Data",
1 - DIVIDE([No Read Count], [Total Number of Pallets], 0))

If you find this helpful , please mark it as solution which will be helpful for others and Your Kudos/Likes 👍 are much appreciated!

Thank You

Dharmendar S

LinkedIN 

[powerbidev123]

Hi @dharmendars007 , i think the return value if condition satisfies should be "No data" instead of blank

No Read Perc =
IF (ISBLANK([No Read Count]) || ISBLANK([Total Number of Pallets]),
"No data",
1 - DIVIDE([No Read Count], [Total Number of Pallets], 0))

[dharmendars007]

Yes We can try out the same also to pass text as "No Data"