Forum Discussion
Solved
How to do make a selection list
Hi community, I am new to Power BI and have learned a lot from your posts. Thank you all very much. Today I met a question. Any answer and hint are much appreciated. I have a table like, T...
and2022 , Unpivot the type column in power bi, and create A,B,C when the type is yes
Or you need to have table with A,b,c as rows, and based on each selection return values
Switch(selectedvalues(Type[Type]),
"A",calculate(Count(Table[id]), filter(Table, Table[Type1] ="Yes")) ,
"B",calculate(Count(Table[id]), filter(Table, Table[Type2] ="Yes")) ,
"C",calculate(Count(Table[id]), filter(Table, Table[Type3] ="Yes"))
)
Got it. Thank you.