Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
@Anonymous,
Glad to hear the issue is solved. You can accept your reply as answer to close this thread.
Regards,
Lydia
@Anonymous,
Please share sample data of your table, and post the formula that you use to create ‘Max of’.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |