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.
Hi,
I would like to take the average of each category and then sum them together without taking to total average. However, currently the sum is the total average.
Currently this is my code:
I am trying to have the total be Average = 0 ´+ 1.71 + 22.88 + 0 +4.6
Solved! Go to Solution.
Hi,
Found a solution
@Anonymous , Try like
AVerage 4 = CALCULATE(
AVERAGEX(
SUMMARIZE( 'Test', 'Test'[category]),
CALCULATE( SUM( 'Test'[value) )
), ALLEXCEPT( 'Test', 'Test'[Category])
)
or
AVerage 4 = CALCULATE(
AVERAGEX(
SUMMARIZE( 'Test', 'Test'[category]),
CALCULATE( SUM( 'Test'[value) )
)
)
Hi,
It is still find the average for each category A,B,C,D,E then for the "total" it is adding each average A, average B.... then dividing by 5. I would just like to to take the average of each category and add them togther
Here is another measure I tried, that gives me the right averages but will not let me sum the values
Hi,
Found a solution
User | Count |
---|---|
77 | |
77 | |
68 | |
67 | |
49 |
User | Count |
---|---|
108 | |
105 | |
93 | |
83 | |
64 |