Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
@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