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.

     

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]))

krypto6969's avatar
krypto6969
Helper II
9 years ago

Thanks! Trying it now.

  • krypto6969's avatar
    krypto6969
    Helper II
    9 years ago

     I can't seem to make the 'new measure' button enabled.

    • parry2k's avatar
      parry2k
      Super User
      9 years ago

      What is your data source?

    • krypto6969's avatar
      krypto6969
      Helper II
      9 years ago

      my data source is a cube so I think that is why I can't add a new measure?

       

      If that is indeed correct, what can I do?

      • parry2k's avatar
        parry2k
        Super User
        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.