Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
luizahenriques
Frequent Visitor

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.

 

luizahenriques_0-1664478424528.png

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

Nota Final Ciclo Anterior = AVERAGEx(VALUES(d_Requisito[Grupo]),[Nota Final (Avaliação Global) - Ciclo Anterior])
 
My question is: How can I do my measure using TWO features?? Group and Company.
 
Thank you so much.
1 ACCEPTED SOLUTION
ahmadibrahimbus
Resolver III
Resolver III

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

View solution in original post

1 REPLY 1
ahmadibrahimbus
Resolver III
Resolver III

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.