How to do a SUM and Distinct of a column with a Group By in DAX

[Anonymous]

I wanted to a create a measure which will do SUM(Distincts [Points]) GROUP BY Transaction_Id in DAX for the given sample data below

Transaction_Id	Points
1	1650
1	1650
1	1650
2	1250
2	1250
2	1250

Please can you help me with the DAX command.

Regards,

Ranjan

[Jihwan_Kim · Accepted solution]

Hi, @Anonymous 

Please correct me if I wrongly understand your question.

Please try the below measure.

sum of distinct points =

VAR groupnewtablesum =

GROUPBY (

'Table',

'Table'[Points],

"@distinctvalue", COUNTAX ( CURRENTGROUP (), 'Table'[Transaction_Id] )

)

RETURN

SUMX ( groupnewtablesum, 'Table'[Points] )

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster.

[Anonymous]

Thanks @Jihwan_Kim , I will try this DAX and shall update.