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:)


Anonymous's avatar
Anonymous
Not applicable
3 years ago

I belive you could just unselect blank values from the filter pane.

 

Have you tried this for each of the categories? 

Let me know if this works, if not I'll have a further look. Thanks and good luck! 🙂