Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
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!
Thanks,
Oliver
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 =
IF (
HASONEVALUE ( StoreTable[StoreName] ),
CALCULATE ( Sales, ALL ( [ProductCategory] ) )
)
Hi Jared,
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!
Olivier
Hi @OliverS,
Have you resolve your issue? If you have resolved it, please mark the helpful reply as answer, if you haven't, please feel free to ask.
Best Regards,
Angelia