Sum distincts in calculated columns

[Digger]

I can count distinct rows with

COUNTROWS(

SUMMARIZE(

FILTER(

_payments

,[order_id] = thisOrderID

&& [type] in {"1","yy"}

)

,

[ID])

)

But how get Sum of distincts IDs? in calculated columns not in measures

[v-eqin-msft]

Hi @Digger ,

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution to make the thread closed. More people will benefit from it.

Best Regards,
Eyelyn Qin

[v-eqin-msft]

Hi @Digger ,

According to how get Sum of distincts IDs ,please try:

Column = SUMX(VALUES('Table'[ID]),[ID])

If it is not your expected output , please provide more detail information(data sample , expected ) to help us clarify your scenario.

How to Get Your Question Answered Quickly - Microsoft Power BI Community

How to provide sample data in the Power BI Forum - Microsoft Power BI Community

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

[amitchandak]

@Digger , You need a group by for that

example

SumX(values(Table[COlumn]), calculate(distinctcount(Table[ID]))

[Digger]

@amitchandak  distinctcount is crashing all report and never complete countings

[amitchandak]

@Digger , the performance alternate, suggested in some video by guyinacude channel 

countx(summarize(Table, Table[ID]),[ID])

Not able to find the video

[Digger]

@amitchandak  yes, but i need sum not count