Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I have to calculate accuracy which in my case is ((Actual Rounds- Expected Rounds)/(Actual Rounds))-1. I have a column for actual Rounds. The way I calculate Expected Rounds is I multiply it with the number of jobs*TierRound. This TierRound is also a column that exists in my table.Number of jobs I calculate by using count(Job Number) . Can anybody help me with this?
Proud to be a PBI Community Champion
The table looks like this. I have created a measure for Total jobs= count(Job Number). I have to get Rounds accuracy, so the accuracy for 4 tiers will be different. Expected Rounds is Total jobs*Rounds. I tried to create a calculated column but there's an error saying there's a circular dependency.
For example if Tier 2 has 20 jobs then expected rounds= 20*2
Tier 3 has 40 jobs then expected rounds=40*3
Tier 4 has 60 jobs then expected rounds= 60*4.
You can ignore the tier Round column. For tier 1 expected round count is 1, tier 2 is 2 tier 3 is 3 and tier 4 is 4.
To get expected rounds we have to mulitply number of jobs in that tier * expected round count.
User | Count |
---|---|
98 | |
90 | |
78 | |
71 | |
64 |
User | Count |
---|---|
112 | |
96 | |
95 | |
67 | |
65 |