Forum Discussion
DAX max of
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 wo...
Anonymous,
Glad to hear the issue is solved. You can accept your reply as answer to close this thread.
Regards,
Lydia
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.
Anonymous,
Glad to hear the issue is solved. You can accept your reply as answer to close this thread.
Regards,
Lydia