Card to work out difference between 2 other cards.

[CA1410]

Hi everyone!

I'm creating a dashboard which shows the results of a survey, I have 2 cards which show the survey response totals and I'd like a card in the middle which works out the difference of the two. However the 2 original cards will be effected by slicers so I can change between each survey, there are around 10 surveys in total.

Is it possible to have this card in the middle which will dynamically change and work out the difference from card 1 and card 2.

Thank you.

[kpost]

Assuming the same filters are affecting all 3 cards, you should just be able to make a measure and subtract the two values, no?

difference_card_value = COALESCE(SUM(TABLE[Response_1]), 0) - COALESCE(SUM(TABLE[Response_2]), 0)


//Mediocre Power BI Advice, but it's free//