Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
I am trying to use the values from two different card visuals (both of which are the result of filtered table data - each from a different table) and make a calculation with these two values.
One card visual is the number of total instances of "Acceptances" and is the result of data being filtered out of Table A (which consists of many statuses beyond just "Acceptances", and a larger timeframe than needed).
The other card visual is the number of total instances of "Declines" and is the result of data being filtered out of Table B (which also consists of other statuses beyond just "Declines", and also a larger timeframe than needed - but works well with the filters in place).
Both tables are from different data sources, so I can't combine them - they're very different datasets.
My ultimate goal is to get to an "Acceptance Rate" which is simply
Acceptances/(Acceptances+Declines)
...and to have that resulting value be displayed on a similar visual card next to those other two values.
Is this possible?
Thank you in advance!
Hey,
to answer your question: "Is this possible?"
Yes, this possible. Unfortunately, it's not that easy as by dividing two card visuals. You have to create a measure, that "hosts" the division.
Here I explained a similar question:
https://community.powerbi.com/t5/Desktop/Operate-with-2-cards/m-p/250139#M110999
If you need further assistance, it will become much more simple, if you provide sample data and describe how both tables are structured and filtered.
Regards
Tom
| User | Count |
|---|---|
| 59 | |
| 46 | |
| 31 | |
| 17 | |
| 16 |
| User | Count |
|---|---|
| 78 | |
| 66 | |
| 44 | |
| 26 | |
| 22 |