Measure error

[Anonymous]

Measure error 

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

Sheet Before 

Name column Team

Guide me please.

[PhilipTreacy · Accepted solution]

Hi @Anonymous 

Try this

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

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

regards

Phil

[PC2790]

Hi @Anonymous ,

Try this:

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

[Anonymous]

@PC2790   

It error as below.

suggest me about it please.

[PC2790]

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]

@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]

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?