Forum Discussion
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...
Here it is
Upside = CALCULATE(SUM('Elbaba breakdown'[Sales LP]), 'Elbaba breakdown'[Category]="UPSIDE")
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"))