Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi Team, i am facing issue in dividin two measures which has row level filters on it. when iam trying DIVIDE function its throwing me error. Help me out here.
Measure 1 = COUNTROWS(FILTER(ADDCOLUMNS(SUMMARIZE('SV Demo','SV Demo'[NationalIdNo],"Distinctpolicies", DISTINCTCOUNT('SV Demo'[PolicyTypeCd])), "policycount", [Distinctpolicies]), [policycount] =2)).
Measure 2 = CALCULATE(DISTINCTCOUNT('SV Demo'[NationalIdNo]),'SV Demo'[PolicyTypeCd] = "BE")
Measure 3 = CALCULATE(DISTINCTCOUNT('SV Demo'[NationalIdNo]), 'SV Demo'[PolicyTypeCd] = "BI")
Measure 4 = Distinctcount('SV Demo'[NationalIdNo]).
I need 3 New measures by Dividing (1st measure with 4th Measure) , (2nd Measure with 4th Measure), (3rd Measure with 4th Measure)
@Ulal , these measures should work, please share error you are getting
Divide([Measure 1],[Measure 4])
Divide([Measure 2],[Measure 4])
Divide([Measure 3],[Measure 4])
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
87 | |
86 | |
75 | |
69 | |
66 |
User | Count |
---|---|
214 | |
128 | |
117 | |
82 | |
76 |