Slicer and Count

[powerbiexpert22]

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 

[amitchandak]

@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