Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Countif in PowerBI

Hi all,   I see that there is no countif in PowerBI. Is there an alternative? In excel I have applied the formula '=COUNTIF(B6:CN6,">0")' In PowerBI I am not sure on how to do it. Can I know ho...
Help appreciated
Help Requested
  • jaideepnema's avatar
    jaideepnema
    4 years ago

    Hi Anonymous ,
    Create a measure like this 

    Count = CALCULATE(COUNT(TableName[ColumnName]),TableName[ColumnName]>0)
     
    Replace tablename and columnname accordingly
     

    Please accept this as a solution if your question has been answered !!

    Appreciate a Kudos ðŸ˜€

    Connect with me on LinkedIn: https://www.linkedin.com/in/jaideepnema/

jaideepnema's avatar
jaideepnema
Icon for Solution Sage rankSolution Sage
4 years ago

Hi Anonymous ,
Create a measure like this 

Count = CALCULATE(COUNT(TableName[ColumnName]),TableName[ColumnName]>0)
 
Replace tablename and columnname accordingly
 

Please accept this as a solution if your question has been answered !!

Appreciate a Kudos ðŸ˜€

Connect with me on LinkedIn: https://www.linkedin.com/in/jaideepnema/