Forum Discussion

dream36876's avatar
dream36876
Frequent Visitor
1 year ago
Solved

Subtotal in Matrix Question

Hi Experts,   I have a matrix calculating warehouse ending inventory. The question is, I can't display "Ending Cost" this columns's total calculation the way I want.   I'm using  AVERAGE...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi dream36876 ,
    You can try this

    Ending_Cost = 
VAR _t = 
SUMMARIZE(
    'Table',
    'Table'[Cost per Unit],
    'Table'[Inventory],
    "Sum", SELECTEDVALUE('Table'[Cost per Unit])*SELECTEDVALUE('Table'[Inventory])
)
RETURN
SUMX(_t,[Sum])

    Fainal output

     

    Best regards,
    Albert He

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

     



dharmendars007's avatar
dharmendars007
Memorable Member
1 year ago

Hello dream36876 

 

Please try with the below formula..if doesnt work please share us the sample dataset to check further.

Measure = Sumx(Values(GdsNa), AVERAGE('Ending Per unit'[Cost per Unit]) * SUM('Ending Inventory'[Inventory]))

If you find this helpful , please mark it as solution and Your Kudos are much appreciated!

 

Thank You

Dharmendar S

LinkedIN 

  • dream36876's avatar
    dream36876
    Frequent Visitor
    1 year ago

    Hello, Thanks for reply 

     

    But it still doesn't work what i want

    I can't share file here,how about sample data?

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      1 year ago

      Hi dream36876 ,
      You can try this

      Ending_Cost = 
VAR _t = 
SUMMARIZE(
    'Table',
    'Table'[Cost per Unit],
    'Table'[Inventory],
    "Sum", SELECTEDVALUE('Table'[Cost per Unit])*SELECTEDVALUE('Table'[Inventory])
)
RETURN
SUMX(_t,[Sum])

      Fainal output

       

      Best regards,
      Albert He

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