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]))
     
     
     
     
NiugeS's avatar
NiugeS
Helper V
5 years ago

Jihwan_Kim This is brililant!  Thank you.. didn't think to unpivot etc.  Much appreciated although I will need to spend some time understanding the measure!