cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jonnyA
Post Patron
Post Patron

Power BI create measure that subtracts

Hello,

I have 2 calculated measures I created ...

Provider % = COUNT( 'Test_Charge_Dataset'[CPT_Code])

Group % = CALCULATE(

[Group CPT Count],
ALL(Test_Charge_Dataset[CPT_Code], Test_Charge_Dataset[Provider_Name]))
How can I create a measure that subtracts Group % minus Provider %?
For example ...
jonnyA_0-1629816388487.png
5 REPLIES 5
v-luwang-msft
Community Support
Community Support

Hi @jonnyA ,

Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.

Best Regards
Lucien

v-luwang-msft
Community Support
Community Support

Hi  @jonnyA ,

I create a sample ,but in my saple ,the measure parry2k provided is correct.

vluwangmsft_0-1629962956179.png

 

Could you pls share your pbix file for test? and remove confidential data.

 

 

Best Regards

Lucien

parry2k
Super User
Super User

@jonnyA not sure why, seems like I'm missing something obvious. Can you share a sample pbix file, remove sensitive information before sharing.






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





parry2k
Super User
Super User

@jonnyA Add the 3rd measure

 

Diff % = [Group %] - [Provided %]

 

Follow us on LinkedIn

 

Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would  Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

 

Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





@parry2k , this is what i get when I use your formula ...

jonnyA_0-1629824303211.png

And I tried all of the "show as" values, howver, that didnt give me the correct % either.

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors