Forum Discussion

luizahenriques's avatar
luizahenriques
Frequent Visitor
4 years ago
Solved

AVERAGEX and total average

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 ...
Need Help
Tutorial Requests
  • ahmadibrahimbus's avatar
    ahmadibrahimbus
    4 years ago

    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])

ahmadibrahimbus's avatar
ahmadibrahimbus
Icon for Resolver III rankResolver III
4 years ago

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])