Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Measure Total Issue

Hello Everyone,   I have seen many questions related to Problem with Measure Total and saw many suggestions but still i couldn't get my answer I want to get the sum of weight of material without...
Need Help
Show and Tell
  • Daniel29195's avatar
    Daniel29195
    2 years ago

    Anonymous 

    re = 
var ds=
ADDCOLUMNS(
    SUMMARIZE(
        FactMoisture,
        DimDate[Date],
        DimLine[Line],
        FactMoisture[Moisture %]),
        "X", FactWeight[Weight_With_Moisture]*(1-DIVIDE(FactMoisture[Moisture %],100))
)
return
SUMX(ds,[X])

     

     

    let me know if it works for you .

     

     

     

     

    If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
    It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠

Daniel29195's avatar
Daniel29195
Community Champion
2 years ago

Anonymous 

re = 
var ds=
ADDCOLUMNS(
    SUMMARIZE(
        FactMoisture,
        DimDate[Date],
        DimLine[Line],
        FactMoisture[Moisture %]),
        "X", FactWeight[Weight_With_Moisture]*(1-DIVIDE(FactMoisture[Moisture %],100))
)
return
SUMX(ds,[X])

 

 

let me know if it works for you .

 

 

 

 

If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hello Daniel29195 ,

Thank you, it worked 🙂