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.
Hi experts,
I'm scratching my head about this trivial problem:
This doesn't work:
=COUNTX(ALL(Table1[Code]), Table1[Sales Amount])
Error msg:
A single value for column 'Sales Amount' in table 'Table1' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result.'.
However the error msg doesn't make sense, COUNTX() is supposed to take a set of values instead of a single value as second parameter, and if anything is wrong, it's probably ALL(), because this works:
=COUNTX(ALL(Table1), Table1[Sales Amount])
Question: Why the first one doesn't work?
Solved! Go to Solution.
Just like SUMMARIZE Function, a single result needs to be returned for each [Code].
Just like SUMMARIZE Function, a single result needs to be returned for each [Code].
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 |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
106 | |
105 | |
86 | |
72 |