Forum Discussion

Berl21's avatar
Berl21
Icon for Helper III rankHelper III
4 years ago
Solved

Error message for a measure - how to interpret it

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.   Range PY = SWITCH(TRUE(),'Leads Amount PY'[...
error message
Need Help
Switch()
  • Berl21's avatar
    Berl21
    4 years ago

    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).

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Berl21 , Rae you trying to add a measure in a calculated column?

Berl21's avatar
Berl21
Icon for Helper III rankHelper III
4 years ago

amitchandak to provide an example, this is the calculated table what I did for all the data (no filter on the year).

Calculated table:

Leads Amount =

SUMMARIZE(
    Leads_Table,
    Leads_Table[ZH_Account__c],
    Leads_Table[Lead_Creation_Date],
    "Count of Leads",
    [Count Leads]
)



I then inserted this measure:

Range = SWITCH(TRUE(),'Leads Amount'[Count of Leads]<3,"1-3",'Leads Amount'[Count of Leads]<5,"3-5",'Leads Amount'[Count of Leads]<10,"5-10")
 
The result appears correctly in the final table:


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 😞