Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Gérard Ducouret]

Hello,

I ‘m trying to run this DAX formula that I found in a book. It’s supposed to create a table with 3 columns. But I always get the error:.
“The expression refers to multiple columns… cannot be converted to a scalar value”

What I’m missing ?
Thanks for your help
Here is the code:

Colors =

ADDCOLUMNS (

VALUES ( ‘Product'[Color] ) ;

“Products”; CALCULATE ( COUNTROWS ( ‘Product’ ) );

“Sales Amount”; [Sales Amount]

)

——————————
Gérard Ducouret
——————————

[Ashley Hsia]

That error ?occurs when your results are more than what is expected (i.e. PBI expected a single value and your feeding it a whole column).   This explains it somewhat:https://www.sqlgene.com/2019/04/30/dax-error-the-expression-refers-to-multiple-columns-multiple-columns-cannot-be-converted-to-a-scalar-value/

In not knowing much about the underlying data/setup, I would suggest beginning to trouble-shoot by making sure you are starting out using the expected format/delivery/result (sorry, I don’t know the technical term here).  What I mean is–are you using “New column” when you should be using “New table”?

Hope that helps,

——————————
AHsia
——————————
——————————————-

[Gérard Ducouret]

Thanks a lot Ashley! You pined the issue!
Now that works

——————————
Gérard Ducouret
——————————
——————————————-

[Cekou C.]

Hi Gérard,

I just tried your formula and it works fine. Maybe you can check your data model and relationships.

——————————
Cekou C.
Accounting Supervisor & PBI Enthusiast
——————————
——————————————-