Forum Discussion
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?
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.
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]))
Thanks! Trying it now.
I can't seem to make the 'new measure' button enabled.
What is your data source?
