Forum Discussion

mmills2018's avatar
mmills2018
Helper IV
5 years ago
Solved

Create Groupings for filter

hello, 

I am using the below measure to calculate Global Women %:

VAR LastDateSnap = LASTDATE(Snapshots[Data As Of]) 
return ROUND((CALCULATE(DISTINCTCOUNTNOBLANK(Snapshots[Associate ID]),Snapshots[Gender]="Female",Snapshots[Data As Of]=LastDateSnap))/(CALCULATE(DISTINCTCOUNTNOBLANK(Snapshots[Associate ID]),Snapshots[Data As Of]=LastDateSnap))+0,3)

 

I need be able to filter by certain levels, for example, I have a field named Management Levels, below is a breakout. The issue I am running into, is I need to create groupings, so M4+, M1-M3,P1-P6, Total PME (PME combine), O1-O4, T1-T4, B1-4. Unfortunately, i need to create these specific groupings.  I am just confused on how i can create the Total (PME) grouping, so i would need to combine all E values, M values and P values.  any ideas?

 

Management Levels
E1
E2
E3
E4
M1
M2
M3
M4
M5
P1
P2
P3
P4
P5
P6
O1
O2
O3
O4
T1
T2
T3
T4
B1
B2
B3
B4

 

what my groupings need to be:

M4+ (M4,M5, E1-E4)

M1-M3 (M1,M2,M3)

P1-P6 (P1,P2,P3,P4,P5,P6)

Total PME (All E, M and P values)

O1-O4

T1-T4

B1-B4

Need Help

3 Replies