Forum Discussion

RvdHeijden's avatar
RvdHeijden
Post Prodigy
9 years ago
Solved

Countif ?

I have a table with all the people that called in sick (a name is not unique in this list and can be in the list more then once) and that is just what i want to know. I need a column that counts the...
Need Help
  • v-huizhn-msft's avatar
    v-huizhn-msft
    9 years ago

    Hi RvdHeijden,

    Based on my understanding, you want to get the second example result form the first one, right? If it is, I try to reproduce your scenario and get expected result.



    Create measures using the following formulas.

    count = CALCULATE(COUNTA(Test1[Name]),ALLEXCEPT(Test1,Test1[Name]))

Total sick days = CALCULATE(SUM(Test1[Total SickDays]),ALLEXCEPT(Test1,Test1[Name]))

    Create a table visual, you will get the expected result.



    Please let me know if you have any questions.

    Best Regards,
    Angelia

RvdHeijden's avatar
RvdHeijden
Post Prodigy
9 years ago

v-huizhn-msft

That worked like a charm :)

 

next question, i now have a table with the name, number of times someone called in sick and the total sickdays.

Some people arent employed with us anymore so i want to look if someone is stille employed but that data is in another table.

 

in excel it would be vert.zoeken or a lookup function but what is it in DAX ?

v-huizhn-msft's avatar
v-huizhn-msft
Microsoft Employee
9 years ago

Hi RvdHeijden,

Glad to hear that your issue got solved. One thread is allowed to ask one qiestion, you'd reopen another case and post your sample data or .pbix file for analysis. Thanks for understanding.

Best Regards,
Angelia

  • RvdHeijden's avatar
    RvdHeijden
    Post Prodigy
    9 years ago

    v-huizhn-msft

    Your right, ill close this one and start a new thread