dax error

[brinky]

I have created a simple measure:

Lasco Category = CALCULATE(

FIRSTNONBLANK(Category[LAS],1),FILTER(Category,Category[Code]='CodeuDesc'[Code]))

which works fine, however when I copy the same measure and remane I'm getting this error...

A single value for column 'Code' in table 'CodeuDesc' 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.

Any ideas why?

[v-gizhi-msft · Accepted solution]

Hi,

Please try to create a calculated column instead of measure.

Hope this helps:

https://community.powerbi.com/t5/Desktop/Error-This-can-happen-when-a-measure-formula-refers-to-a-co... 

Best Regards,

Giotto Zhi

[Zubair_Muhammad]

@brinky 

As the error message says you have to specify an aggreagtion

For example: Selectedvalue,max or min

Lasco Category =
CALCULATE (
    FIRSTNONBLANK ( Category[LAS], 1 ),
    FILTER ( Category, Category[Code] = SELECTEDVALUE ( 'CodeuDesc'[Code] ) )
)

[brinky]

Thanks for your reply, but I'm not getting any results 😐