Sum Distinct with condition

Hi neto22 ,

I try to learn set analysis in Qlik and understand it's calcualte logic by myself. And I think you are trying to sum the [Last Original Limit] with out duplicates (Distinct) with the condition that [Limit Flg] = "S".

I suggest you to try this code.

My Sample:

Measure:

Convert the code = 
SUMX (
    SUMMARIZE (
        FILTER ( 'Table', 'Table'[Limit Flg] = "S" ),
        'Table'[Last Original Limit]
    ),
    [Last Original Limit]
)

Result is as below.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.