Forum Discussion

yhael1121's avatar
yhael1121
Frequent Visitor
8 years ago
Solved

scalar value

Hi Team,    Im a new user. i was working on adding a calculated column on a table but i kept on getting this error: The expression refers to multiple columns. Multiple columns cannot be converted t...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    8 years ago

    Right, so you are adding the column to the table but then returning the entire table back. You can't do that in a calculated column or a measure. This would be a valid formula for a calculated table however.

     

    Seems like you could create a new calculated column and give it this formula:

     

    72Hrs = AVERAGEX(RELATEDTABLE(Compressed),[72HR])

    I'm making some assumptions here. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

yhael1121's avatar
yhael1121
Frequent Visitor
8 years ago

Hi Greg,

 

thanks for the feedback. but actually, i really dont know how to explain my situatiom. originally, i was working on a chart but was not satisfied with the result. what i would love to see with my chart is an option on what metric to show since this chart is on a daily basis. and i came accross this forum saying that we can use DAX in creating the visual that i want. now im having a much complicated issue. thank you though, i will study my dashboard more maybe i can figure this one out on my own. 

 

Thanks,

Marielle

Greg_Deckler's avatar
Greg_Deckler
Community Champion
8 years ago

yhael1121- So, typically, the best way to get a useful answer is to post some sample/example data that can be copied and pasted. This can be accompanied by screen shots of table relationships, etc. Then post a screen shot or mock-up of what you are trying to achieve. 

 

If we understand your source data and we understand what you are trying to achieve, we can generally get you a solution.