Forum Discussion
Card change on filter
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
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
3 Replies
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
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))Yes We can try out the same also to pass text as "No Data"
