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

     



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