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
Hi,
In the Query Editor, right click on the first column's heading and select "Unpivot Other Columns". Write this measure
Count = calculate(countrows(Data),Data[Value]=0)
Hope this helps.
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.