Creating a measure, based on two filtered cards from same table, and producing a card based on it

[TheKiltedGolfer]

I have Table A that has a “Name” column (text format), “DateTime” column (datetime format), “Window” column (text format) and an “Emails Received” column (integer).  The “Window” column has many options including “4PM”, “5PM”, “6PM”, etc. I have created two cards with filters on them.  One titled (say Card A) “Total count of distinct names that can receive emails for timeframe” that counts distinct names for multiple selected “DateTime” AND multiple selected “Window” no matter the email count. The other card (Card B) is titled “Total count of distinct names that received emails for timeframe” that counts distinct names for multiple selected “DateTime” AND multiple selected “Window” with email counts NOT 0. So far so good?  These two cards work fine for me.  But now I need a third card (Card C) based on these two.  The formula would be (Card A – Card B)/Card A.  I do not know how to create a measure to do this.  I would then want Card C to be the outcome of the measure. I tried doing it based on what I found in the Power BI forums but they fail and do not produce a number.  I am not sure how to incorporate the filters into a measure either.  Can anyone help me?  Or am I making this way too complicated and should be doing this a different way altogether?

[V-lianl-msft · Accepted solution]

Hi @TheKiltedGolfer ,

According to your description, I tested it. It can't be realized in a table. When I cancel the interaction of slicer, it can't get the value of card visual(Because measure is calculated according to the current context).

So I copied the table, which is feasible, and got the result you want.

Please refer to the pbix

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.