How to count a value in column based on grouping (DAX)?

[aiyosap]

Hi all,

I am trying to create a calculate column using COUNT function to derive the count value of the "Case Number" based on the column of "File Date" grouping. 

For some reason my calculate row derived value as showin in column C (count), but that is incorrect. 

It should be a value like in column D (The Count that I want). How to write such kind of DAX? Thanks.

Regards,

Aiyo

[smpa01 · Accepted solution]

@aiyosap 

Measure= calculate (count(tbl[case number]), allexcept(tbl, tbl[case number],tbl[file date]))

[Anonymous · Accepted solution]

Hi  @aiyosap ,

Here are the steps you can follow：

1. Create calculated column.

Count_Column = CALCULATE(COUNT('Table'[Case Number]),FILTER(ALL('Table'),'Table'[File Date]=EARLIER('Table'[File Date])&&'Table'[Case Number]=EARLIER('Table'[Case Number])))

2. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[LozzieDuff]

Hi Liu,

Why the need for an ALL() in your answer? I tried it in my context without the ALL() and it appears to work. But you had something in mind presumably that I might not be experiencing (yet!) but would like to know what it is.

Thanks in advance.

[smpa01 · Accepted solution]

@aiyosap 

Measure= calculate (count(tbl[case number]), allexcept(tbl, tbl[case number],tbl[file date]))