Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
do you have a workaround?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
46 | |
28 | |
22 | |
12 | |
8 |
User | Count |
---|---|
76 | |
51 | |
44 | |
16 | |
12 |