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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
brodaddy02
New Member

subtracting 2 measures

I think I have a softball question, but I am not sure.  I have 2 measures that produce the correct results.

 

Measure 1) Distinct_Mentor_Group_Billets:=COUNTROWS(DISTINCT(tbl_Raw[UIC+BSC]))

Measure 2) Primary_Mentor_Group:=COUNTA(tbl_Raw[Primary Mentor Group])

 

Both columns contain text data.  I am trying to create a new measure that subtract the number of billets by the number of people

Desired Measure) Delta Group:=[Primary_Mentor_Group]-[Distinct_Mentor_Group_Billets]

 

The numbers are not working correctly.  Does anyone have a suggestion?  

2 REPLIES 2
brodaddy02
New Member

I have attached a picture of the data.  I am pretty new to posting.  I think I have to something wrong with filters.  

Data.jpg

az38
Community Champion
Community Champion

Hi @brodaddy02 

Normally, it should works, but the exact result depends on what exactly do you need

As a very first "blind" suggestion try to obtain both of measures into CALCULATE() 


do not hesitate to give a kudo to useful posts and mark solutions as solution
LinkedIn

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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