Forum Discussion

CA1410's avatar
CA1410
New Member
3 years ago

Card to work out difference between 2 other cards.

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.

 

 

Need Help

1 Reply

  • kpost's avatar
    kpost
    Icon for Solution Sage rankSolution Sage
    3 years ago

    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//