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 have a measures
Solved! Go to Solution.
Hi @v-kongfanf-msft @amitchandak i was able to get it fixed by
Hi @saud968 ,
Did @amitchandak reply solve your problem? If so, please mark it as the correct solution, and point out if the problem persists.
Best Regards,
Adamk Kong
@v-kongfanf-msft the solution did not work I have shared further thoughts. Any further help is appreciated
I will be trying it out now and will update
@saud968 , Try like
Option1:
CID = CALCULATE(COUNT(support__cw_ops_manage_case_merge_temp[ID]), filter('Colleague List', 'Colleague List'[Location] IN {"Australia", "United Kingdom", "United States", "Philippines"}))
Use the cental Fact in the summarize
Avg = AVERAGEX(SUMMARIZE(Attendance, 'Colleague List'[BU],Attendance[Present days]),[CID])
Option2
P CC =
VAR CurrentAvg = [Avg count Closed Cases]
VAR GroupAvg = CALCULATE(
[AvgClosedCasesByBUAndLocation],
ALLEXCEPT('Colleague List', 'Colleague List'[BU]),
'Colleague List'[Location] IN {"Australia", "United Kingdom", "United States", "Philippines"}
)
RETURN
DIVIDE(CurrentAvg, GroupAvg)
Hi @v-kongfanf-msft @amitchandak i was able to get it fixed by
Hi @amitchandak I tried this
Hi @amitchandak thank you for the quick response. Unfortunately both options did not work, as you can see in the screenshot above
When I pulled AvgClosedCasesByBUAndLocation in a separate table visual it gave a constant average for BU for example it 1.88 for Automate and Manage as 2.05 so basically I wanted to divide the Avg count Closed Cases/ AvgClosedCasesByBUAndLocation which should give me desired number however, if you check when I do that in the table above the AvgClosedCasesByBUAndLocation gives the same number as Avg count closed cases.
User | Count |
---|---|
83 | |
69 | |
68 | |
65 | |
54 |
User | Count |
---|---|
93 | |
91 | |
91 | |
76 | |
70 |