Sum Distinct with condition

[neto22]

Hello guys,

Qlik has a language called set analysis, which allows you to create formulas through conditions.

SUM({$<[Limit Flg] = {'S'}>}DISTINCT(NUM(CEIL([Last Original Limit]))))))

I'm trying to reproduce the same concept in DAX in PBI, but so far I haven't been successful.

Can someone help me?

Thanks 😄

[Anonymous · Accepted solution]

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.

[ryan_mayu]

@neto22 

could you pls provide the sample data and expected output?