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
abukapsoun's avatar
abukapsoun
Post Patron
6 years ago

Hi,

 

I tried the below formula, still same behavior

Upside = CALCULATE(SUM('Elbaba breakdown'[Sales LP]), FILTER('Elbaba breakdown', 'Elbaba breakdown'[Category]="UPSIDE"))

 

Datatype is Decimal.. i tried to play with that by changing the decimals, but still the same

 

Filtering with CT that has the upside, table & chart shows the upside, but the card doesnt.

 

I created a new measure to make sure nothing has to do with interaction, but still the same 

 

this is really weird S:

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

    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

  • 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!

  • 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 ??