Allocated budget per user

[Anonymous]

Hi,

I have a requirement where i need to calculate :

• cost per user per product
• sliced by Empl and Date tables

Per User cost per product is monthly budget per product divided by count of users from Usage table.I tried to created count of users from Usage table and created a calculated column in Budget table that provided per head cost per product based on headcount measure fromo USage table but not knowing how to get to fulfil the requirement in an optimum way.Hence ,pls show and tell how to get to the requirements.Attaching the sample model examplehttps://drive.google.com/file/d/1dCpvsmTsNvsJ_PzYMnyEsIcKyeeXMKY6/view?usp=sharing :

[Anonymous]

Can someone please provide ideas for this.