Forum Discussion

powerbiexpert22's avatar
powerbiexpert22
Icon for Impactful Individual rankImpactful Individual
2 years ago

Slicer and Count

I am using below sample data

1) I want to show Module as drop down like below

2) I want to show ID count based on selected module like below

example If I select Module1 and Module2 then Count should show 1

 

Drop Down:

 

 

 

 

 

Sample Data:

 

When both Module1 and Module2 are selected : it should show ID count as 1 

 

 

 

 

 

Need Help

1 Reply

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    2 years ago

    powerbiexpert22 , Unpivot the columns, you will modules on the row along with the value column( post rename)

     

    New =

    var _cnt = calculate(distinctcount(Table[Module]), allselected())

    var _module = calculate(distinctcount(Table[Module]), filter(Table, Table[Value]=1))

    return 

    if(_cnt = _module , _module , blank())

     

     

    And for Selected Values, All selected values are present: https://youtu.be/X5T4rIZovHk