Help to solve distinct value in month

[18520148]

Please help me some Power BI Experts, I have problem like the first picture when I extracted data. My table with the ID repeated the values each month

Can anyone help me to write a DAX formula to Sum the distinct value group by ID and each Month like following table. Thank you very much.

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure if I understood your data model correctly without seeing the actual one, but please try the below measure.

Distinct value sum measure: =
SUMX (
    ADDCOLUMNS (
        SUMMARIZE ( 'table name', 'table name'[MONTH], 'table name'[ID] ),
        "@distinctvalue", CALCULATE ( MAX ( 'table name'[VALUE] ) )
    ),
    [@distinctvalue]
)

[18520148]

It's really help me. Thank you so much.