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
tex628's avatar
tex628
Community Champion
6 years ago

Your image link is broken!

Br,
J

abukapsoun's avatar
abukapsoun
Post Patron
6 years ago

Hi,

 

I have modified the initial post, there was an extra space in the link

 

please try again 

https://ibb.co/KGHVVBT

 

thanks

  • tex628's avatar
    tex628
    Community Champion
    6 years ago

    Could you possibly provide the dax for the measure? 

    • abukapsoun's avatar
      abukapsoun
      Post Patron
      6 years ago

      Here it is

       

      Upside = CALCULATE(SUM('Elbaba breakdown'[Sales LP]), 'Elbaba breakdown'[Category]="UPSIDE")
       
       
      • tex628's avatar
        tex628
        Community Champion
        6 years ago

        From the information you provided there is absolutly no reason as to why this would return blank() in that card. This is really quite strange... 

        Give this a try and just check if you get the same issue.

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