IS there any work around how to use different aggregations for columns and rows?
Not really sure what you are meaning with this question.
Can you be more specific and show an example of what you are talking about?
Calculations in Power BI occur via 1. the context of the calculation and then 2. the formula applied to that context.
Both of these combine to create any answer you see or need to create in a visualisation.