Forum Discussion
Count all values in table that share same value as current row in pivot table
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
2 Replies
- AnonymousNot applicable"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- AnonymousNot applicable
do you have a workaround?