Forum Discussion

abukapsoun's avatar
abukapsoun
Post Patron
6 years ago

Measure behaving weirdly?

Hi,   I have a simple measure that is working fine when I add it into graph or table, but when I use it in a card, it is showing blank.   Snapshot in the following link https://ibb.co/KGHVVBT (S...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi,

 

Try creating a new measure based on you old measure

 

Upside - Card = IF(ISBLANK('Elbaba Breakdown'[Upside]), 0, 'Elbaba Breakdown'[Upside]).
 
 
abukapsoun's avatar
abukapsoun
Post Patron
6 years ago

Upside - Card = IF(ISBLANK('Elbaba Breakdown'[Upside]), 0, 'Elbaba Breakdown'[Upside]) 

-> didn't work

 

I tried to re-create exactly the same clustered bar chart which shows the upside. But in the new chart, the upside is not appearing! 

 

I tried refresh, save and exit but all negative!

  • abukapsoun's avatar
    abukapsoun
    Post Patron
    6 years ago

    Guys! I just found out there was a slicer filter that I wasn't taken into consideration. things are fine now.

     

    Thank you very much

  • tex628's avatar
    tex628
    Community Champion
    6 years ago

    Double check so that you dont have any visual level filters that could cause this on your visuals! 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Could you check if there is any data for the upside column, becuase in the image it has value(0.2) on only one record.

     

     

  • abukapsoun's avatar
    abukapsoun
    Post Patron
    6 years ago

    Hi,

     

    there is no visual filters

     

    I have filtered by another quarter (Q4), now you can see 3 CTs showing this upside in the chart and table, but the card is still blank

     

    snapshot here 

    https://ibb.co/r0YtzcN

     

    And finally a hint. I filtered by quarter (Q3).. and now I can see the upside value in the card. 

    snapshot here

    https://ibb.co/Fh4K3c7

     

    What could that be ??