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

July 28 - August 9 | Final Round of the Power BI Dataviz World Championships. This is your chance. Learn more

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
FabCon and SQLCon Barcelona 2026

FabCon & SQLCon – Barcelona 2026

Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.

Fabric Community Sticker Design Challenge Barcelona Carousel

Fabric Community Sticker Challenge - Barcelona 2026

If you love stickers, then you will definitely want to check out our community sticker challenge, Barcelona edition!

July Power BI Update Carousel

Power BI Monthly Update - July 2026

Check out the July 2026 Power BI update to learn about new features.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

Top Solution Authors