Filter results out of a measure

[Pseifert]

Hello,

I am trying to filter and only sum up values where the Measure>=3. Here is my measure: 

SumInOut = SUMX(Values('NorthtecPunchOrigin'[FULLNM]),Calculate(SUM(NorthtecPunchOrigin[INOUT])))

In a single card, this measure results below. My issue is that I can not get this 752 value in a single card because I cant filter out those unique values unless the FULLNM column is introduced.

[helassal · Accepted solution]

Hi,

One way to do it is, to first create a calculated table to hold full names and sum of values, then use "Filter" to filter out summed values => 3 , then sum the values in the filtered table to get the value you need.

SumInOut =
VAR AggTable =
    FILTER (
        SUMMARIZE ( 'Table', 'Table'[Names], "SumVal", SUM ( 'Table'[val] ) ),
        [SumVal] >= 3
    )
VAR result =
    CALCULATE ( SUM ( 'Table'[val] ), AggTable )
RETURN
    result

Regards,

Haitham

[Anonymous]

would this work?

SumInOut = SUMX(Filter( NorthtecPunchOrigin, NorthtecPunchOrigin[SumInOut] <=3), [SumInOut])