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! 🤠

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Daniel29195 

 

Thank you for your quick reply. I tried your suggestion, but it is showing me a total of 170 instead of 84.

Also in your measure you mentioned  :  

,
        FactWeight[Weight_With_Moisture]

I could not write this in my measure.  

 

Corrected Measure =

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


Could you again help me? 🙂

Daniel29195's avatar
Daniel29195
Community Champion
2 years ago

Anonymous 

are you able to sharethe power bi file ? 

you can upload to google drive, dropbox and share a link. 

 

NB:
the measure that i ve wrote , is the logic of how it should be done. 

since i dont have an idea of the data that you have how it is spreaded. 

 

 

 

    • 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 🙂