Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Dear Community,
based on the photo above, I want to add 1 columns for calculating mean value per row(77+78+78.97+79.01+79.50), how can I handle it?
I tried to do it throught new quick maesure --> average per category --> but it does not work it gaves 5 coulmn! I want 1 column for calculating mean of these 5 values.
Thanks in advance
Solved! Go to Solution.
@Anonymous , if 1,2,3,4,5 are meausres or column in values
you can have measure
([1]+[2]+[3]+[4]+[5])/5 // assume all are measures
If the are category values, you need to change Row total
New Measure = Calculate([Average Measure], allexcept(Table, Table[Cluster], Table[Stain], Table[label]))
Use isfilterted or isinscope to change the row total
if(not(isinscope([Category])) , [New Measure ],[Measure])
@Anonymous
Try using AVERAGEX
Measure Avg =
IF (
HASONEVALUE ( 'Table'[Index] ),
[Measure],
AVERAGEX ( VALUES('Table'[Index]), [Measure] )
)
@Anonymous , if 1,2,3,4,5 are meausres or column in values
you can have measure
([1]+[2]+[3]+[4]+[5])/5 // assume all are measures
If the are category values, you need to change Row total
New Measure = Calculate([Average Measure], allexcept(Table, Table[Cluster], Table[Stain], Table[label]))
Use isfilterted or isinscope to change the row total
if(not(isinscope([Category])) , [New Measure ],[Measure])
User | Count |
---|---|
96 | |
86 | |
78 | |
72 | |
67 |
User | Count |
---|---|
110 | |
104 | |
84 | |
65 | |
63 |