Forum Discussion

eunji888888's avatar
eunji888888
Frequent Visitor
1 year ago

MAXX measure wrong value

I found that there is a mistaken value in the MAXX function. The maxx gives all the same value, 24, which is the maximum for the whole list instead of filtering the selected material. Are there an...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
Ray_Minds's avatar
Ray_Minds
Solution Supplier
1 year ago

Hi  eunji888888

I have tried to replicate your scenario which is as follows: 

 

1. By SO table  
 

 

 

2. Combined Group Discount table 
 

 

 

By looking at the above sample data I provided for both tables, we can deduce: 

(I) For Material A, max value will be 25 (Extracted from Discount field). 

(II) For Material B, max value will be 30 (Extracted from Discount field). 

(III) For Material C, max value will be 20 (Extracted from Discount field). 

 

Visual Output : 

For A 

 

For B 

 

For C 

 

 

 

 

 

Matching as expected. In my model, I am utilizing a bridge table to establish a relationship between the 'By So' and 'Combine Group Discount' tables, as I anticipate that both tables contain duplicate values in the material column. If you could kindly share a sample dataset along with the relationships you have defined, it would greatly facilitate troubleshooting and help us resolve the issue more efficiently. Thank you! 

If your requirement is solved, please make THIS ANSWER a SOLUTION ✔️ and help other users find the solution quickly. Please hit the LIKE 👍 button if this comment helps you.