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,
I added a calculated table to my data with values for the previous year, and then tried to add a measure using Switch.
This is what I wrote.
I get the following error message:
A single value for column 'Count of Leads PY' in table 'Leads Amount PY' 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.
The thing is I took the exact same steps for the current year, it works without a hitch and there is no aggregation there either. Is there another way to interpret this error message? What else can I check to make sure it works as intended?
Solved! Go to Solution.
Ok, I got it. The problem was indeed that it was a measure @amitchandak . Beginner mistake 😑
For anyone who reads this, this should be made over a calculated column based on the calculated table (instead of with a measure).
Ok, I got it. The problem was indeed that it was a measure @amitchandak . Beginner mistake 😑
For anyone who reads this, this should be made over a calculated column based on the calculated table (instead of with a measure).
@Berl21 , Rae you trying to add a measure in a calculated column?
@amitchandak to provide an example, this is the calculated table what I did for all the data (no filter on the year).
Calculated table:
I then inserted this measure:
I am now trying to reproduce this with a change to the first step (filter for the previous year). But for some reason that I don't understand, I get this error message about an aggregation issue 😞
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 |
---|---|
49 | |
25 | |
20 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |