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
Im sorry but i dont understand what you are saying, where can i find the Query Editor because when i go to 'Edit Queries' i only have an 'Advanced Editor' and not a 'Query Editor'.
Besides im looking for a formula but in your example is that something i can use in the visuals or just a a matrix
With Query Editor I meant Edit Queries.
Apparently you are looking for a DAX solution.