Forum Discussion

NiugeS's avatar
NiugeS
Helper V
5 years ago
Solved

Adding Up A Score for Values in a Column

Hi all,   I've been playing with something that is likely quite simple but having difficult working out how to do it.  I have two tables one consisting of names/items with a yes / no if they have t...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    5 years ago

     

    Score measure : =
    CALCULATE (
    SUMX ( Inventory, RELATED ( Score[Score] ) ),
    FILTER ( Inventory, Inventory[Value] = "Yes" )
    )
     
     
    Score measure ALL : =
    SUMX(Inventory, RELATED(Score[Score]))
     
     
     
     
Jihwan_Kim's avatar
Jihwan_Kim
Super User
5 years ago

 

Score measure : =
CALCULATE (
SUMX ( Inventory, RELATED ( Score[Score] ) ),
FILTER ( Inventory, Inventory[Value] = "Yes" )
)
 
 
Score measure ALL : =
SUMX(Inventory, RELATED(Score[Score]))