DAX max of

[Anonymous]

Hi, 

I'm using the formula 

sumx(DISTINCT(Table1[Customer ID]),([Max of TO])) and it works fine - I have the sum of max TO per a disinct Custemer ID, 

Unfortunatly the same formula dosent works for onather Value and I cant find why - 'Max of' can't be calcualted

Both are Currency, decimal. 

Thank you. 

[v-yuezhe-msft]

@Anonymous,

Please share sample data of your table, and post the formula that you use to create ‘Max of’.

Regards,
Lydia

[Anonymous]

Hi, thank you!

I found how to solve it.

it works good in the first case because excel creates automatically a hide formula for calculation of max of TO…

sumx(DISTINCT(Table1[Customer ID]),([Max of TO]))

for the columns that the abouve formula dosen’t works there is no such hidden formula automaticaly created (i dont know why)

I write it manually and it’s working now.

[v-yuezhe-msft · Accepted solution]

@Anonymous,

Glad to hear the issue is solved. You can accept your reply as answer to close this thread.

Regards,
Lydia