Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Dynamic Table in DAX expression

Hello All, I have the below dataset of products and store information. I would like to have a simple DAX Expression which returns Product and total sales. Main Dataset: City Product A ...
DAX
Table
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Ankit,

I tried above formula and it gave me the error viz. The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value.

Did you tried this dax in your test pbix ?IF so, can you please upload the sample pbix ?

  • AnkitKukreja's avatar
    AnkitKukreja
    Icon for Super User rankSuper User
    5 years ago

    Hi Anonymous 

     

    I believe calculate table or unpivot is the only option according to me.

    Let's see if we can get any other solution.

     

    Thanks,

    Ankit

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Calculate table will have an issue of static data. Because it won't have dynamic data. Unpivot is also a one-time solution and the same challenge of static data. Thanks, Ankit for looking into though.

      • AnkitKukreja's avatar
        AnkitKukreja
        Icon for Super User rankSuper User
        5 years ago

        Hi Anonymous 

        But, unpivot would be added as a step in your query editor and it would update as your data is updated everytime. Just thinking it out loud, if you might have missed that point.
        Anyways, thanks and good luck.