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.
I am attempting to perform a CALCULATE function that provides me with the overall % breakout by Disposition Value [field] by Month. I am using the following formula:
Solved! Go to Solution.
@Anonymous , Try
Disposition % = DIVIDE(SUM(Query1[BHMP_SVC_FLG]),CALCULATE(COUNT(Query1[BHMP_SVC_FLG2]),filter(all(Query1), Query1[Metric_Month] = max(Query1[Metric_Month]))))
or
Disposition % = DIVIDE(SUM(Query1[BHMP_SVC_FLG]),CALCULATE(COUNT(Query1[BHMP_SVC_FLG2]),removefilters( Query1[Disposition]) ))
@amitchandak : Thank you very much for responding to my post! The top formula provided me with the desired results I was looking for. I did change the Numerator from "SUM" to "COUNT", but the % of Total for each month was correctly calculated thereafter. I greatly appreciate your assistance.
@Anonymous , Try
Disposition % = DIVIDE(SUM(Query1[BHMP_SVC_FLG]),CALCULATE(COUNT(Query1[BHMP_SVC_FLG2]),filter(all(Query1), Query1[Metric_Month] = max(Query1[Metric_Month]))))
or
Disposition % = DIVIDE(SUM(Query1[BHMP_SVC_FLG]),CALCULATE(COUNT(Query1[BHMP_SVC_FLG2]),removefilters( Query1[Disposition]) ))
User | Count |
---|---|
52 | |
48 | |
20 | |
16 | |
15 |
User | Count |
---|---|
109 | |
45 | |
42 | |
24 | |
20 |