Power BI create measure that subtracts

[jonnyA]

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 ...

[v-luwang-msft]

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]

Hi  @jonnyA ,

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

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

Best Regards

Lucien

[parry2k]

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

[parry2k]

@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.⚡

[jonnyA]

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

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