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

Here it is

Upside = CALCULATE(SUM('Elbaba breakdown'[Sales LP]), '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:
- 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
    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
  Community Champion
  6 years ago
  If you remove the row dimension from the table it returns blank there aswell right?

Related content