Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Measure error

Measure error    Measure = CONCATENATE("Update") & CONCATENATE( 'Before'[Team])   Sheet Before  Name column Team   Guide me please.
Need Help
  • PhilipTreacy's avatar
    PhilipTreacy
    5 years ago

    Hi Anonymous 

    Try this

    Measure = CONCATENATE("Update", MAX('Before'[Team]))

    If that doesn't work please supply some sample data.

    regards

    Phil

PC2790's avatar
PC2790
Community Champion
5 years ago

As you are creating a measure of the column containing multiple values, you are getting this error as it requires an aggregation on the column level.

 

Try creating a calculated column rather than a measure. This will fix your issue.

 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

PC2790 yes, in​ column​ department have​ more​ value.

Now​, if​ i​ use​ card​ for​ show​ department, it​ show​ correct.

But​ I​ want​ to​ add​ text​ before​ department

 

Suggest​ me​ please.

  • PC2790's avatar
    PC2790
    Community Champion
    5 years ago

    Can you be more elaborative about your issue?

    It would help is you can explain using your data examples and screenshots.

     

    Also, ss your initial issue of concatenating the two values- "Update" & Before [Team] column sorted?