Forum Discussion
Solved
Create a slicer with binary information from multiple columns
Hi guys, I have a customer count table as per below: Customer Count = the count of customer with the attribute on the right. Use 1st row for instance, there is 1 customer with Mu...
Hi ljx0648
To get the desired result :
You need to unpivot the table from PQ :At this stage you can create simple dax measure :
Count_Y = CALCULATE(COUNTROWS('Table'),'Table'[Value]= "Y")Result :
Pbix is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Hi ljx0648
To get the desired result :
You need to unpivot the table from PQ :
At this stage you can create simple dax measure :
Count_Y = CALCULATE(COUNTROWS('Table'),'Table'[Value]= "Y")
Result :
Pbix is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
