sum values of a list of unique values

[Anonymous]

Hello, I'm having trouble displaying a list of unique values for a second line of code that sum only the Lbs of values in that list, here is my code:

Total LT = 
VAR list = CALCULATE(VALUES('DATA BASE'[OP]),'DATA BASE'[EE] = "LT")
RETURN
CALCULATE(SUM('DATA BASE'[Lbs]),'DATA BASE'[OP]=list)

here's a example of my data base (is a lot more bigger):

i want the list of the OP's that has some value in EE = LT, for later sum the total Lbs of that OP

Thanks

[camargos88 · Accepted solution]

Hi @Anonymous ,

Try this measure:

Measure = CALCULATE(SUM('Table'[Lbs]); SELECTCOLUMNS(CALCULATETABLE('Table'; 'Table'[EE] = "LT"); "OP"; 'Table'[OP]))

If you consider it as a solution, please mark as a solution and kudos.

Ricardo

[harshnathani]

Hi @Anonymous ,

You can use the below measures.

Total LBS = SUM('Data Base'[LBS])

TOTAL LBS BY OP = CALCULATE(

[Total LBS],

FILTER(ALLEXCEPT('Data Base','Data Base'[OP]),'Data Base'[EE] = "LT"))

Regards,

Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!!

[Anonymous]

Thank you @harshnathani , but this is not the result I'm expecting, the measure should sum all the values of the OP only if at least one are in LT, kind of first get rid of the list all the OP's that doesn't have at least one value with EE = LT, after that, sum all Lbs of each OP of this new list whatever the EE is. (i would like to graphic the EE values of every OP in a stacked column chart)

here i did a little example of the steps: 

Thank you again for your help.

[harshnathani · Accepted solution]

Hi @Anonymous ,

Please try the below measure:

CALCULATE (
   [Total LBS],
    FILTER (
        SUMMARIZE (
           'Data Base',
            'Data Base'[OP],
            'Data Base'[EE],
            "OP1",
            IF (
                'Data Base'[EE]
                 =
                    "LT",
                    1,
                    0
            )
        ),
       [OP1]
         =
            1
    )
)

Regards,

Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!!

[camargos88 · Accepted solution]

Hi @Anonymous ,

Try this measure:

Measure = CALCULATE(SUM('Table'[Lbs]); SELECTCOLUMNS(CALCULATETABLE('Table'; 'Table'[EE] = "LT"); "OP"; 'Table'[OP]))

If you consider it as a solution, please mark as a solution and kudos.

Ricardo