Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

filter for (multiple select with AND)

parry2k multiple select with AND    I have one more layer to the problem presented in the post "multiple select with AND". I recap the essential issues.   I have the same two lists of keywords: C...
  • parry2k's avatar
    2 years ago

    Anonymous the quick solution without changing existing measures is to improve the model using following approach:

     

    "Text cause" table used for cause slicer will have record for both high-risk and low-risk

     

     

    "Text Effect" table will have a record for each risk category, see below:

     

     

    There will be a new table for risk category selection and I called it "Risk Category"

     

     

     

    And this is how these tables will be connected:

     

     

    and as you will make the risk selection, cause and effect slicers will be changed accordingly. Let's start with this and see if it works for you. The only issue I see with this is that if low-risk or mid-risk is selected, the user still has to select the Effect in the slicer even if it has one choice. If we want the measure to work without the user having to select the effect then we need to update the measure.