https://community.fabric.microsoft.com/t5/Developer/Allocated-budget-per-user/m-p/1283130#M25154 <P>Hi,</P><P>I have a requirement where i need to calculate :</P><UL><LI>cost per user per product</LI><LI>sliced by Empl and Date tables</LI></UL><P>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 example<A title="Sample" href="https://drive.google.com/file/d/1dCpvsmTsNvsJ_PzYMnyEsIcKyeeXMKY6/view?usp=sharing" target="_self">https://drive.google.com/file/d/1dCpvsmTsNvsJ_PzYMnyEsIcKyeeXMKY6/view?usp=sharing</A>&nbsp;:</P><P>&nbsp;</P> Mon, 10 Aug 2020 02:46:31 GMT Anonymous 2020-08-10T02:46:31Z https://community.fabric.microsoft.com/t5/Developer/Allocated-budget-per-user/m-p/1283130#M25154 <P>Hi,</P><P>I have a requirement where i need to calculate :</P><UL><LI>cost per user per product</LI><LI>sliced by Empl and Date tables</LI></UL><P>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 example<A title="Sample" href="https://drive.google.com/file/d/1dCpvsmTsNvsJ_PzYMnyEsIcKyeeXMKY6/view?usp=sharing" target="_self">https://drive.google.com/file/d/1dCpvsmTsNvsJ_PzYMnyEsIcKyeeXMKY6/view?usp=sharing</A>&nbsp;:</P><P>&nbsp;</P> Mon, 10 Aug 2020 02:46:31 GMT https://community.fabric.microsoft.com/t5/Developer/Allocated-budget-per-user/m-p/1283130#M25154 Anonymous 2020-08-10T02:46:31Z https://community.fabric.microsoft.com/t5/Developer/Allocated-budget-per-user/m-p/1304160#M25315 <P>Can someone please provide ideas for this.</P> Tue, 18 Aug 2020 12:54:51 GMT https://community.fabric.microsoft.com/t5/Developer/Allocated-budget-per-user/m-p/1304160#M25315 Anonymous 2020-08-18T12:54:51Z