Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Challenge when aggregating

I am losing sleep over this one.. Any help is appreciated! I need help with an expression in power BI DAX measure. I have two tables with the following relationship. 'Dim_Time'[Date] 1 -> * Fact_KS...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Anonymous ,

     

    [CM LY Price effect] is a measure, and then the formula is multiplied by [Total net weight] and [Total net weight], so your total is also two totals multiplied. If you want to solve this problem, you can create a new measure and then use the SUMX function.

     

    Measure = SUMX('TableName',[CM LY Price effect])

     

     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.           

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Anonymous ,

 

[CM LY Price effect] is a measure, and then the formula is multiplied by [Total net weight] and [Total net weight], so your total is also two totals multiplied. If you want to solve this problem, you can create a new measure and then use the SUMX function.

 

Measure = SUMX('TableName',[CM LY Price effect])

 

 

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.