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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Regular Visitor

## How to Do Sum/ Subtraction between 2 Visuals in PowerBI

Hi all,
I was wanting to know if there's a way to do a calculation between 2 visuals like the ones below:

I want to be able to find the difference between the 2 months
IE: what is the difference between May 2024 & June 2024 Merchang Violation Number like with a formula in Excel.

Thanks for any help

1 ACCEPTED SOLUTION
Super User

Hi @Ike0911 ,

You should use measures to achieve this. Create a measure for each visual using SUM, AVERAGE, etc. Then create a third measuere which is measure1 - measure 2.

Here is more information:

https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-measures

3 REPLIES 3
Super User

You can use the COUNT function inside of a measure to get the number of string values in a column:

https://learn.microsoft.com/en-us/dax/count-function-dax

Super User

Hi @Ike0911 ,

You should use measures to achieve this. Create a measure for each visual using SUM, AVERAGE, etc. Then create a third measuere which is measure1 - measure 2.

Here is more information:

https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-measures

Regular Visitor

Hi DJ,

Unfortunately the information in those columns  is in Text format & so I can't do a measure.

I just did a count of all items in the list to come up with the Number in each box (but the data itself is text format [ Company names/ url's...] )

Thanks for the information and assistance.

I will keep it for future reference 🙂

Regards,

Ike

## Helpful resources

Announcements

#### Power BI Monthly Update - July 2024

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

#### Fabric Community Update - July 2024

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

Top Solution Authors
Top Kudoed Authors