Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live 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 |
|---|---|
| 53 | |
| 40 | |
| 35 | |
| 24 | |
| 22 |
| User | Count |
|---|---|
| 134 | |
| 107 | |
| 57 | |
| 43 | |
| 38 |