Forum Discussion

and2022's avatar
and2022
New Member
4 years ago
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...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    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"))

    )

amitchandak's avatar
amitchandak
Super User
4 years ago

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"))

)