I'm totally new to PowerBI and dax and I'm using the Contoso sample file.
From the following grid, I'd like to add a new measure that would Sum SalesAmount for each Store (StoreName and SalesAmount are coming from 2 different - but linked - tables):
Goal is to get the contribution of each ProductCategory to StoreTotal.
Any advise would be warly welcome!
Hi @OliverS, just to confirm, is SalesAmount a measure or column? And you want to show the full sales amount for the store on each row? If I understand you correctly, here's how I would approach this:
Sales = SUM ( SalesTable[SalesAmount] )
Store Sales =
HASONEVALUE ( StoreTable[StoreName] ),
CALCULATE ( Sales, ALL ( [ProductCategory] ) )
Yes, SalesAmount is a column.
When trying this approach, the validation error message is "The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value."
Still puzzled to see how such an important feature in a BI report is hard to do.
Thanks for your help!