Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

Reply
another1here
Frequent Visitor

Calculation using two card values

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!

 

1 REPLY 1
TomMartens
Super User
Super User

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 



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Kudoed Authors