The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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?
I have attached a picture of the data. I am pretty new to posting. I think I have to something wrong with filters.
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()
User | Count |
---|---|
77 | |
77 | |
36 | |
30 | |
28 |
User | Count |
---|---|
106 | |
96 | |
55 | |
49 | |
46 |