Forum Discussion

ksobota's avatar
ksobota
Regular Visitor
9 years ago
Solved

DAX Function for COUNTIF and/or CALCULATE

Hello,   I am fairly new to Power BI and am even newer to the use of DAX functions. For years I have worked in Excel and know how I would do this there, but am finding the same formula I would use ...
Need Help
  • v-caliao-msft's avatar
    v-caliao-msft
    9 years ago

    Hi ksobota,

     

    Based on your scenario, you can use the DAX below on your INDIVIDUAL table.

    CountUser = CALCULATE(COUNTA(EMPLOYMENTS[Member_C]),FILTER(ALL(EMPLOYMENTS),EMPLOYMENTS[Member_C]=INDIVIDUAL[User_ID]))

     

     

    Regards,

    Charlie Liao

zairol_hamdan's avatar
zairol_hamdan
Regular Visitor
6 years ago

Hi there, I'm having this issue as well. Did you manage to solved? Tks

EILOOP's avatar
EILOOP
Advocate I
6 years ago

On Page 2 of the thread...

 

I was able to accomplish this through variables.

 

For example I wanted to count the times an employee name appeared in my employee name column, since each row is unique to the entire column i stored this value as a var in Formual Bar.

 

This will work just like a Count If based on the current value of the Row.

 

Column Name = 

     var employee_name = Table[Employee Name]

     var Outcome = CALCULATE(COUNT(Table[Employee Name]),FILTER(Table,Table[Employee Name]= employee_name))

Return

Outcome