Forum Discussion

NavyaMounika's avatar
NavyaMounika
Helper I
1 year ago
Solved

Need Intersection results when select multiple option from Slicer

Hi All,   I have a dataset which contains multiple columns in which i have to focus only on 3 column basically which have been listed here Account, Task Name and Baseline. Below is the sample data....
Need Help
  • v-echaithra's avatar
    v-echaithra
    1 year ago

    Hi NavyaMounika ,

    May I ask if you have gotten this issue resolved?

     

    If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.

     

    Regards,
    Chaithra.

Akash_Varuna's avatar
Akash_Varuna
Super User
1 year ago

Hi NavyaMounika You will need to create two measures one for slection of vanila and the other for selection for non vanila could you please try these

Vanilla Accounts = 
CALCULATE(
    DISTINCTCOUNT('Baseline'[Account]),
    'Baseline'[Baseline] = "VANILLA",
    ALLEXCEPT('Baseline', 'Baseline'[Task Name])
)
Non-Vanilla Accounts = 
CALCULATE(
    DISTINCTCOUNT('Baseline'[Account]),
    'Baseline'[Baseline] <> "VANILLA",
    ALLEXCEPT('Baseline', 'Baseline'[Task Name])
)

 Now set the slicer to filter on Task Name

NavyaMounika's avatar
NavyaMounika
Helper I
1 year ago

Hi Akash,

Thank you for your quick response.

In the above scenario we have to create 2different slicers.

Is there any option to use only one slicer to showcase my requirement.

 

Thanks in Advance!

 

Regards,

Navya

  • NavyaMounika's avatar
    NavyaMounika
    Helper I
    1 year ago

    Hi All,

     

    Can anyone help me out in this scenario.

     

    Thanks in Advance!

     

    Regards,

    Navya