Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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 |
---|---|
103 | |
88 | |
78 | |
71 | |
69 |
User | Count |
---|---|
113 | |
99 | |
97 | |
72 | |
68 |