Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi All,
I have a monthwise coverage value for the divisions and have a group coverage value highlighted in green.
The monthwise covearge values for all the divisions to be summed up(15.66+22.50+20.76+25.97=84.89) and divided by the group coverage value (84.89/84.91)and calculating the AVG coverage value (for 2017-01, (84.89/84.91) =100% .pls see the below Coverage AVG), finally i have to find the YTD Avearge . its a average of all the months coverage AVG
Please tell me how this can be achieved by DAX . Thanks in advance.
Regards,
P.Kalidoss
Solved! Go to Solution.
Is the Group number just a static value?
Looks like you would want to import your top table, Month, Div1, Div2, Div3, Div4 although you might want to import it as:
Month,Division
2017-01,15.66
2017-01,22.50
2017-01,20.76
2017-01,25.97
...
Then you could create a measure like:
Grand Total = SUM([Division])
If your Group is in its own table, you could create a measure:
Measure = Table1[Grand Total] / Table2[Group]
You would need another table for your bottom table and could do a simple average of the values.
Hi @sivadoss87,
Have you tried the solution provided by @Greg_Deckler? Does it work in your scenario?
If it works, could you accept it as solution to close this thread? If you still have any questions, feel free to post it here.
Regards
Is the Group number just a static value?
Looks like you would want to import your top table, Month, Div1, Div2, Div3, Div4 although you might want to import it as:
Month,Division
2017-01,15.66
2017-01,22.50
2017-01,20.76
2017-01,25.97
...
Then you could create a measure like:
Grand Total = SUM([Division])
If your Group is in its own table, you could create a measure:
Measure = Table1[Grand Total] / Table2[Group]
You would need another table for your bottom table and could do a simple average of the values.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
120 | |
101 | |
71 | |
61 |