Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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...
Need Help
  • deevaker's avatar
    deevaker
    3 years ago

    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

     

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi

COUNT0 =
var col1=COUNTROWS((filter(Feuil4,Feuil4[Column 1]=0)))
var col2=COUNTROWS((filter(Feuil4,Feuil4[Column 2]=0)))
var col3=COUNTROWS((filter(Feuil4,Feuil4[Column 3]=0)))
return
col1+col2+col3