Forum Discussion

TFTF_BI's avatar
TFTF_BI
Icon for Helper I rankHelper I
4 years ago
Solved

Categorising 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...
  • Anonymous's avatar
    Anonymous
    4 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