Forum Discussion

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

Here it is

 

Upside = CALCULATE(SUM('Elbaba breakdown'[Sales LP]), 'Elbaba breakdown'[Category]="UPSIDE")
 
 
tex628's avatar
tex628
Icon for Community Champion rankCommunity 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"))