Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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])
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
97 | |
82 | |
74 | |
66 |
User | Count |
---|---|
121 | |
105 | |
102 | |
82 | |
72 |