measure formula refers to a column that contains many values

[Anonymous]

Hi,

how we can solve  this  error  :

I checked file  logo, the  error  message  in the  below :

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

[v-lili6-msft]

hi, @Anonymous 

First you need to know that a measure operates on aggregations of data defined by the current context.

So it needs to use min, max, count, or sum to get a single result

https://www.sqlbi.com/articles/calculated-columns-and-measures-in-dax/

Second, if you still have the problem, just share some sample data and your fromula with the expected output.

Best Regards,

Lin

[Anonymous]

thanks @v-lili6-msft ,

I used cont in measure , but the same error shows, after that I remove measure  and check refersh, in power bi desktop refreshing but once save in  power bi report server not refreshing

[v-lili6-msft]

hi, @Anonymous 

Could you please share your sample pbix file for us have a test?

for "in power bi desktop refreshing but once save in  power bi report server not refreshing", if you could republish it and try it again.

Best Regards,

Lin