Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

cost per user per application

Hi, I am trying to solve this problem from long time and no solution yet.Can someone pls help me acheive the below results in the ilame from the moddel attached.Pls feel free to change the model if ...
Show and Tell
vanessafvg's avatar
vanessafvg
Icon for Community Champion rankCommunity Champion
6 years ago
can you explain what the problem is, is it that the data is not adding up correctly, you dont say what the actual issue is with the data provided. what is the condition for the headcount measure
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Headcount measure should be distincount of user filtered by HC[Flag]=true 

    In the model attached,below is the calculation :

    HC = CALCULATE(DISTINCTCOUNT(Empl[Employee]),FILTER(RELATEDTABLE(HC),HC[Flag]=TRUE()))
    The HC measure is not couting correctly if you see the matrix visual in the report.
    Also,the cost$ measure in model uses sumx which i do not want to use and it slows down performance in my real dataset
    Pls suggest alternative to sumx.
    • vanessafvg's avatar
      vanessafvg
      Icon for Community Champion rankCommunity Champion
      6 years ago

      when i look at your report, it isn't counting jreeves who is set to false, so how is it incorrect, can you give a way to test it?

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        From the matrix,you see that HC counts pjohn as 1 (for Oracle)which shouldnt be the case as Usage table doesnt have pjohn using Oracle. Second,the cost$ is wrong as well because it counts ORacle as 2 users instead of 1 for June and divided cost by 2.Actually,i should get the below output :

         

    • vanessafvg's avatar
      vanessafvg
      Icon for Community Champion rankCommunity Champion
      6 years ago
      can you also explain the purpose of what cost is trying to do? divide the unit cost into the users?
      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Here is the requirement:

        There are 3 products in the Budget table: Salesforce, ORacle, and Telecom. Each of them has a $ monthly allocation in the budget table. I divide the monthly allocation into the $ cost per user based on the HC measure. The HC measure must calculate the count of users per product filtered by HC [Flag] =1.Monthly alocation per product divided by this HC will give unit cost. This unit cost will be used to calculate the costs rolled up to fields in the Empl and Date dimensions.