Hi @MYNKJAIN ,
Mismatched aggregation is a common error for users. I would recommend referring to this resource and it talks through common mismatched aggregation use cases and potential solutions for each of them. Here is the resource (Finding solutions for mismatched aggregation errors in Quick Sight calculations - Learn / Technical Articles - Amazon Quick Suite Community). Check it out and let me know if this helps!