Forum Discussion
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...
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
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
Your right, ill close this one and start a new thread