Forum Discussion
Mutually Exclusive Member count
Anonymous
Wher is your source data and how does look? And, what kind of output are you expecting?
Please share some sample data,
If you are satisfied with my answer, please mark it as a solution so others can easily find it.
Don't forget to give KUDOS to replies that help answer your questions
Subscribe to ExcelFort: Learn Power BI, Power Query and Excel
Sample Data:
id blue red black white 1 Y Y Y Y 2 N Y N N 3 N N Y N 4 N N N Y 5 Y Y N Y 6 Y N Y Y In visulation:
i need to sow nour slicers
P1,P2,P3&P4
P1 RED WHITE BLUE BLACK simillarly P2,P3 & P4
i need Output:
If user select dynamically P1,P2,P3&P4 selections
Note:P1,P2,P3&P4 single slections
Example: user select P1=Red next priority P2(selction Options)=White,BLue,Black , simillarly P3&P4
High importance:
one person eligible One Priority, Next Priority he wont come.
User select dynamically.
Output:
Selection Total Count P1(red) 3 P2(white) 2 P3(Blue) 0 P4(Black) 1 Note: Total count should be all Y counts.
Thanks,
Saikiran