Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

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 works for onather Value and I cant find why - 'Max of' can't be calcualted

 

Both are Currency, decimal. 

 

Thank you. 

  • Anonymous's avatar
    Anonymous
    8 years ago

    Anonymous,

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

    Regards,
    Lydia

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Anonymous,

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

    Regards,
    Lydia

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      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's avatar
        Anonymous
        Not applicable
        8 years ago

        Anonymous,

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

        Regards,
        Lydia