Forum Discussion

nataliesmiy1357's avatar
nataliesmiy1357
Icon for Helper IV rankHelper IV
1 year ago
Solved

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...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • dharmendars007's avatar
    dharmendars007
    1 year ago

    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's avatar
powerbidev123
Icon for Solution Sage rankSolution Sage
1 year ago

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's avatar
dharmendars007
Icon for Memorable Member rankMemorable Member
1 year ago

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