Forum Discussion

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...

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

Community Champion

6 years ago

Could you possibly provide the dax for the measure?

abukapsoun
Post Patron
6 years ago
Here it is

Upside = CALCULATE(SUM('Elbaba breakdown'[Sales LP]), 'Elbaba breakdown'[Category]="UPSIDE")
- 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"))
- Anonymous
  Not applicable
  6 years ago
  Hi,
  
  Could you check the datatype for that measure? i.e. make sure it is a Decimal Number with decimal places.
  
  Ans also try selecting the CT column where Upside is not null just to check if the card is working or not.
  - 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:

Related content