Forum Discussion
Helper IIIcalculate average across columns for all the selected data
1. select columns from “Total Energy” to the last one except “athlete” and “time (mm:ss)”
click Transform->unpivot columns
2. Close and apply, then come back to data model view, create a new table
Table1 = SUMMARIZE(FILTER(Sheet1,[athlete]="AKLIOUCHE MAGHNES"),[Attribute],[avg],[time (mm:ss)],[Value],"as","z-avgall")
3. Union two tables
Table2 = UNION(Sheet1,Table1)
4. Finally, in Report View, use matrix as below
Here is my pbix
Best Regards
Maggie
Community Support1. select columns from “Total Energy” to the last one except “athlete” and “time (mm:ss)”
click Transform->unpivot columns
2. Close and apply, then come back to data model view, create a new table
Table1 = SUMMARIZE(FILTER(Sheet1,[athlete]="AKLIOUCHE MAGHNES"),[Attribute],[avg],[time (mm:ss)],[Value],"as","z-avgall")
3. Union two tables
Table2 = UNION(Sheet1,Table1)
4. Finally, in Report View, use matrix as below
Here is my pbix
Best Regards
Maggie
vishnuprashanthThank you so much v-juanli-msft.
I just tried this and it works perfectly.
I also found an alternate solution by creating HASONEVALUE function for each column and adding it to the report as a separate table. But your solution works better and is comparatively easier. thanks again :)