AP Data SUM based on multiple variables

Hi Seth4040 

Thanks for the reply from samratpbi .

Seth4040, not quite sure what your desired result is, I used the following measure to calculate the sum of the Line Amount of the two OPS Centers in the sample data.

Total Inv Amount = 
SUMX(
    SUMMARIZE(
        'Table',
        'Table'[OPS Center],
        "LineAmount", MAX('Table'[Line Amount])
    ),
    [LineAmount]
)

Output:

If you need further help, please feel free to let me know. It would be even better if you could give expected results based on example data. Please remove any sensitive data in advance.

Best Regards,
Yulia Xu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.