Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I need to get the average between 3 companies (Rating1 + Rating2 +Rating3)/3 in Total line. But the total show the grouped calculation as I seeing in my report.
The total that I would like to see is (7,08+7,25+7,86)/3 = 7,39. However, my measure already has a table VALUES to do the same calculation to the feature d_Requisito[Grupo].
Solved! Go to Solution.
Hello @luizahenriques ,I don't know if I understand you correctly but this measure provide you with the disred number:
AVERAGEX(
VALUES('Table Name'[Attribute]),
CALCULATE(AVERAGE(Table Name'[Attribute])
Hello @luizahenriques ,I don't know if I understand you correctly but this measure provide you with the disred number:
AVERAGEX(
VALUES('Table Name'[Attribute]),
CALCULATE(AVERAGE(Table Name'[Attribute])
User | Count |
---|---|
127 | |
108 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |