Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Total with many condition

Hi, Here's my table:   How can I calculate the volume of a RUN (or many RUN) by choosing a length who was produce in this (or these) RUN? e.g. length 8. Only in the RUN M241 for a total vol...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    I succeeded to have the expecting result. In another table I have the Run so I made this measure and it works:

    CALCULATE(CALCULATE(SUMX(table;table[Volume]);ALL(table[Length]);RELATEDTABLE(RUN))

    Thanks for your support.
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi,

This is a screen shot of expected result when filtered bu User_ID and Length.

This is the complexity. I'm looking for a measure who gives expecting result with many different filter.

Thanks

Anonymous's avatar
Anonymous
Not applicable
6 years ago

I succeeded to have the expecting result. In another table I have the Run so I made this measure and it works:

CALCULATE(CALCULATE(SUMX(table;table[Volume]);ALL(table[Length]);RELATEDTABLE(RUN))

Thanks for your support.