Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
@Andrew_na_lang TRy this measure:
Avg Rating = CALCULATE(AVERAGE(Rating Columne),ALLEXCEPT(CustomerTable,Customer Name Column))
@Andrew_na_lang , Try like
AverageX(Values(Table[Customer]), calculate(Max(Table[Rating])))
User | Count |
---|---|
98 | |
90 | |
77 | |
71 | |
64 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |