topic Re: Count all values in table that share same value as current row in pivot table in DAX Commands and Tips

Count all values in table that share same value as current row in pivot table

Anonymous — Tue, 28 Apr 2020 12:44:14 GMT

I am trying to count all values in a table that have the same value as the current row.

I have a duplication key and I want to see how many time this key shows up in the rest of the table.

Duplication key:

=CONCATENATE(CONCATENATE([Total Weight kg],"-"),[Total Net Value])

Key Count:

=COUNTAX(ALL('Invoice Data'),CONCATENATE(CONCATENATE([Total Weight kg],"-"),[Total Net Value])=[Duplication Check Key])

But at the moment I am getting this:

410.556-0	11912
3702.224-0	11912
869.4-0	11912
408.29-0	11912
1356.356-0	11912
361.496-0	11912
1773.014-0	11912
1240.89-0	11912

If I do the same thing without the ALL function:

=COUNTAX('Invoice Data',CONCATENATE(CONCATENATE([Total Weight kg],"-"),[Total Net Value])=[Duplication Check Key])

I only count items in the current row and I count all of them.

The issue with power query is that you cannot simply use "@"[column] like you can in a table. Please help

Re: Count all values in table that share same value as current row in pivot table

Anonymous — Tue, 28 Apr 2020 17:58:38 GMT

"The issue with power query is that you cannot simply use "@"[column] like you can in a table."

What does it mean? I don't get it... In Power Query you can do ANYTHING. You just have to know how. Power Query is more powerful for data munging than DAX. For instance, in PQ you can use recursion. This is not possible in DAX.

Best
D

Re: Count all values in table that share same value as current row in pivot table

Anonymous — Tue, 28 Apr 2020 18:10:35 GMT

do you have a workaround?