Forum Discussion

krypto6969's avatar
krypto6969
Helper II
9 years ago
Solved

Difference between two cards - with pic

Hi,

 

I am brand new to PowerBI. I have created a new report works fine but I have two cards that have two totals - sums.

 

How do I display the difference amounts in another card? 

Need Help
  • parry2k's avatar
    parry2k
    9 years ago

    That is what I assumed and yes you cannot add a measure if your source is a cube. In this case,  you need to add a calculated field in the cube for the difference and then use that to show as a card.

     

7 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    krypto6969 Create a measure. Right click on query name (table) add measure

    I'm assuming those are fields, if so, it would look something like

    Difference = CALCULATE(SUM('tablename'[PaymentPMPM]) - SUM('tablename'[AmountPaid]))