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

Reply
Ike0911
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:

Ike0911_0-1720642622274.png

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
djurecicK2
Super User
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

View solution in original post

3 REPLIES 3
djurecicK2
Super User
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

 

djurecicK2
Super User
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

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
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

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