Average rating per customers

[Andrew_na_lang]

Hi Fam,

I need help again! I am really confused and can't think straight. 

how can I get the average rating per customer?

I have the customer table and the Orders table that has all the ratings given by the customer. 

I already have the total count of ratings in the table. 

 

[Tahreem24]

@Andrew_na_lang TRy this measure:

Avg Rating = CALCULATE(AVERAGE(Rating Columne),ALLEXCEPT(CustomerTable,Customer Name Column))

[amitchandak]

@Andrew_na_lang , Try like

AverageX(Values(Table[Customer]), calculate(Max(Table[Rating])))