Forum Discussion
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 ...
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 ?
Hi Anonymous
You're right this will not work in measure, i've used this as a Calculated table.
I missed you're point that you don't need a calculated table. So I'll let other folks provide you the solution, as I'm not aware about the same.
Will post my solution, when I'll get to it.
Thanks
Ankit