Forum Discussion
How to aggregate multiple records in a table?
Hi guys, I need your help. I've run out of attempts. It seems so simple, but I couldn't do it. 1) I just need to sum/avg/max up all the values of a single record. For instance, I want 16 n_...
sylvioros Try the below Measures.
Sum_n_certif_B = SUM(YourTable[n_certif_B])
Avg_Total_Certif = AVERAGE(YourTable[% total certif])
Max_n_certif_B = MAX(YourTable[n_certif_B])
Avg_Total_Certif_Selected = CALCULATE( AVERAGE(YourTable[% total certif]), FILTER(YourTable, YourTable[Name] = SELECTEDVALUE(YourTable[Name])) )
Total_Certif_A_B = CALCULATE( SUM(YourTable[n_certif_A]) + MAX(YourTable[n_certif_B]), FILTER(YourTable, YourTable[Name] = SELECTEDVALUE(YourTable[Name])) )