Could we slice the cost as this:
= SUMMARIZECOLUMNS('Date'[Date], 'Empl'[Country], "Budget", [Budget])
Calculate cost per product per user from budgeted data
PV
21
Reputation points
Hi,
I have a requirement where i have the following data model and unable to arrive a correct measure for calculating cost per product per user.I want to be also able to slice by date and empl dim.
Can someone pls correct and post ideas to achieve above.Attached is a sample models.I have 2 models and both are not allowing me to achieve what i want.
The second model merges 2 tables :Usage and HC.This has 7m rows and allows me to get correct HC filtered by date dim but i am not getting the cost
Any help on this please??
1 answer
Sort by: Most helpful
-
Lukas Yu -MSFT 5,816 Reputation points
2020-08-18T08:28:52.06+00:00