Forum Discussion
TFTF_BI
Helper I
4 years agoCategorising into groups using a result from a calculated measure to use in a visual.
Hi Guys, Im stuck on the below. So I have a measure which gives me a total average percentage of increase or decrease. Example: (Im comparing students attendance against 2 time frames. 'thi...
- Anonymous4 years ago
Hi TFTF_BI ,
Here are the steps you can follow:
1. Create calculated column.
Flag = SWITCH( TRUE(), 'Table'[Count_Students_Attendance_Improved]=0.15,"Did not significantly change (>-0.05 & <0.05)", 'Table'[Count_Students_Attendance_Improved]=0.5,"Did not improve (<-0.05)", 'Table'[Count_Students_Attendance_Improved]=0.35,"Improved (>0.05)")2. Create measure.
Improved = COUNTX(FILTER( 'Table','Table'[Flag]="Improved (>0.05)"),[Flag])Did not improve = COUNTX(FILTER( 'Table','Table'[Flag]="Did not improve (<-0.05)"),[Flag])Did not significantly change = COUNTX(FILTER( 'Table','Table'[Flag]="Did not significantly change (>-0.05 & <0.05)"),[Flag])3. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Anonymous
4 years agoNot applicable
Hi TFTF_BI ,
Here are the steps you can follow:
1. Create calculated column.
Flag =
SWITCH(
TRUE(),
'Table'[Count_Students_Attendance_Improved]=0.15,"Did not significantly change (>-0.05 & <0.05)",
'Table'[Count_Students_Attendance_Improved]=0.5,"Did not improve (<-0.05)",
'Table'[Count_Students_Attendance_Improved]=0.35,"Improved (>0.05)")
2. Create measure.
Improved =
COUNTX(FILTER( 'Table','Table'[Flag]="Improved (>0.05)"),[Flag])Did not improve =
COUNTX(FILTER( 'Table','Table'[Flag]="Did not improve (<-0.05)"),[Flag])Did not significantly change =
COUNTX(FILTER( 'Table','Table'[Flag]="Did not significantly change (>-0.05 & <0.05)"),[Flag])
3. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly