Forum Discussion
Counting a distinct value in multiple columns
Hello PBI community! I was wondering how I can count a distinct value on multiples column at the same time. As In the example below, I need a measure to count how many zeros (total) there are on colu...
Not sure if i missed to understand, but if you need to add all the count of zeros, you can write this
Measure =CALCULATE(Count('Table'[Column1]),'Table'[Column1]=0)+CALCULATE(Count('Table'[Column2]),'Table'[Column2]=0)+CALCULATE(Count('Table'[Column3]),'Table'[Column3]=0)
below is the screenshot for reference
Thank you Ashish, I wanted to avoid this step of unpivoting the columns.. Deevaker's solution below worked better for me. Thanks for replying.
You are welcome.