Forum Discussion

MITeam's avatar
MITeam
Frequent Visitor
3 years ago
Solved

Selected Measure (Parameter) to exclude Categories

Hi   I have a parameted that switches the left column of a table to cycle through D&I elements.    Each of the D&I elemtnes (Age / Gender / Ethnicity etc) have "Not Captured" - This is the bulk s...
Need Help
  • olgad's avatar
    olgad
    3 years ago

    Hi, 

    _INC/EXC =

    switch

    (max('Your Parameter Table Name'[Parameter Order]),
    1, if(SELECTEDVALUE('Table'[Gender])="Not Disclosed", "Exc", "Inc"),
    2, if(SELECTEDVALUE('Table'[Nationality])="Not Disclosed", "Exc", "Inc"))

    Place it onto Visual Filters, Contain Inc
    Just in case shoing to you how it goes with my data
    _INC/EXC =

    switch

    (max('Field Parameter'[Parameter Order]),
    1, if(SELECTEDVALUE('Product'[Category])="Mix", "Exc", "Inc"),
    2, if(SELECTEDVALUE('Product'[Segment])="Extreme", "Exc", "Inc"))

    Please kudo and accept the solution if it helps:)


olgad's avatar
olgad
Resident Rockstar
3 years ago

Hi, 

_INC/EXC =

switch

(max('Your Parameter Table Name'[Parameter Order]),
1, if(SELECTEDVALUE('Table'[Gender])="Not Disclosed", "Exc", "Inc"),
2, if(SELECTEDVALUE('Table'[Nationality])="Not Disclosed", "Exc", "Inc"))

Place it onto Visual Filters, Contain Inc
Just in case shoing to you how it goes with my data
_INC/EXC =

switch

(max('Field Parameter'[Parameter Order]),
1, if(SELECTEDVALUE('Product'[Category])="Mix", "Exc", "Inc"),
2, if(SELECTEDVALUE('Product'[Segment])="Extreme", "Exc", "Inc"))

Please kudo and accept the solution if it helps:)


  • MITeam's avatar
    MITeam
    Frequent Visitor
    3 years ago

    Looks cleaner than the solution I managed - Thankyou