Forum Discussion

Himaja95's avatar
Himaja95
Helper I
3 years ago

Powerbi Desktop

Hey Guys, Please help

I am getting the below  error,

A single value for column 'Focus' in table 'Sheet3' 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 sing.

 

while i am trying to write a code for the web imported data lao ,while i am trying to write a code,by creating a new measure,it doent show the data information.

Need Help

1 Reply

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    3 years ago

    Himaja95 You will need to wrap any column references in a measure with an aggregation like SUM, MAX, MIN, etc. Like:

    Measure = SUM( 'Sheet3'[Focus])