Forum Discussion

lesg's avatar
lesg
Frequent Visitor
3 years ago
Solved

Measure Total Incorrect

Hi Guys,    I have created a measure to calculate the value of items based on quantity * cost Cover Value = SUM('View_Inventory_with_Locations'[cost]) * [Cover] The vaules of the items are cor...
Need Help
  • tex628's avatar
    tex628
    3 years ago

    Try this but replace "Item" and "Item[Number]" with whatever dimension you're using in the matrix. 

    Measure = 
SUMX(
SUMMARIZE( Item , 
Item[Number], 
"Value" , SUM(View_Inventory_with_locations[cost]) + [Cover]
), [Value]
)

     
    Br, 
    J

lesg's avatar
lesg
Frequent Visitor
3 years ago

Many thanks for that suggestion, not exactly sure I understand this, as it seems very complex, but will go through the other links and try to understand this issue and the cause.