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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
jonnyA
Responsive Resident
Responsive Resident

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.



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


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.



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


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.

jonnyA
Responsive Resident
Responsive Resident

@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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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