Forum Discussion

setis's avatar
setis
Post Partisan
7 years ago
Solved

Measure*Measure

Hi experts!   I have a measure calculating the total costs   On a table with a list of customers I have a measure showing the %of activities generated by customer.    I just want a measure to m...
Need Help
  • setis's avatar
    setis
    7 years ago

    The calculations are actually right. 

     

    I realized that I had a filter in my TotalBalance table and that's why I was getting wrong results. Thanks for your help. 

     

     

AlB's avatar
AlB
Community Champion
7 years ago

Hi setis

 

I think you'll need to provide some more details. What is it exactly that you are getting wrong? What values are you getting and what do you expect? What is the code for the measures you are using and where/how are you using them? Probably info on your data model will be necessary as well. What is the purpose of the CALCULATE in [AllocatedCosts] ?

 

Cheers

setis's avatar
setis
Post Partisan
7 years ago

Sure!

 

The idea is to calculate the customer profitability. 

I have a list of fixed costs that I want to alocate based on the Nr of activites generated by customer. 

 

The relevant measures:

TotalBalance = SUM(Costs[Balance])

TotalActivities = COUNT(Activitied[CaseID])

Percentage of Activities = DIVIDE([ActivityCount];CALCULATE(Activities[ActivityCount];ALL(Customers_ACT[Customer])))
 
What I'm trying to do is (TotalBalance * Percentage of activities) on a line by line in order to alocate the costs on every customer based on the nr of activities on their cases. 
 
The measure that I'm trying is :
AlocatedCosts = SUMX(
                VALUES(Customers[Customer]);
                [TotalBalance]*[Percentage of Activities])
but the values obtained are wrong and the sum at the botom is not equal to the TotalBalance.
 
I hope that this makes sense. I would prepare a pbix as an example but one of my posts got marked yesterday as spam and I guess that it was due to a link to a google drive shared file. 
  • AlB's avatar
    AlB
    Community Champion
    7 years ago

    setis 

     

    Hmmm... sorry I still don't fully get it. I'd need to see the data model to see the relationships and check what is going on when the measures are invoked from the SUMX. I don't think posting the URL to a file would be a problem at all, it souldn't at least. Perhaps try with tinyupload.com or filedropper.com but I've seen many post with links to google drive      

    • setis's avatar
      setis
      Post Partisan
      7 years ago

      The calculations are actually right. 

       

      I realized that I had a filter in my TotalBalance table and that's why I was getting wrong results. Thanks for your help.