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. 

     

     

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.