Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Need Help on Countifs functionality

Hi Everyone,   A very quick and easy question. I just wanted to count the number of rows/entity based on different column. Its pretty easy in excel but I am unable to find the way in PowerBI. Belo...
@countifs functionality @Need Helop
  • Greg_Deckler's avatar
    Greg_Deckler
    5 years ago

    Anonymous - So you could create a column or measure like:

    Measure = 
  VAR __Name = MAX([Name])
  VAR __Class = MAX([Class])
RETURN
  COUNTROWS(FILTER(ALL('Table'),[Name]=__Name && [Class]=__Class))

Column = 
  VAR __Name = [Name]
  VAR __Class = [Class]
RETURN
  COUNTROWS(FILTER('Table',[Name]=__Name && [Class]=__Class))

     

Greg_Deckler's avatar
Greg_Deckler
Community Champion
5 years ago

Anonymous - So you could create a column or measure like:

Measure = 
  VAR __Name = MAX([Name])
  VAR __Class = MAX([Class])
RETURN
  COUNTROWS(FILTER(ALL('Table'),[Name]=__Name && [Class]=__Class))

Column = 
  VAR __Name = [Name]
  VAR __Class = [Class]
RETURN
  COUNTROWS(FILTER('Table',[Name]=__Name && [Class]=__Class))

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Greg_Deckler ,

     

    Thank you so much, I have created a calculated column and its working perfectly.

     

    Kudos to you! Thank you for the quick support.

     

    Regards

    Uphar