Field Parameters and matrix visual for 3 different Totals

[Anonymous]

Hi Community, 

I am working on a requirement where we have field parameters to deal with dimensions . Also , we have matrix visual to show measures like Current year, Prev Year, Prev quarter, yoy % etc. Thats all working as expected . However, business have asked us to show 3 different totals beneath the matrix visual.  (Pic shown below highlighted in red  ) 

For first total, i am using the default total and unable to find a way to show other 2 Totals as matrix will only one Total. I have created 2 different columns and trying to pull them into matrix to show MYAB payment and MYAB - Total ADsk .But it is not working as expected. is there a way where we can show 3 different measures or columns as totals in power bi matrix ? 

kindly assist . 

[v-zhengdxu-msft]

Hi @Anonymous 

Unfornately that the matrix doesn't work this way. The row and column attributes should be values in columns, while in your case and are not values, but columns. 

Maybe this links can help:

powerbi - Power BI: Combine multiple measures in a single matrix - Stack Overflow

Solved: Showing a Measure as a Total Column only on Matrix - Microsoft Fabric Community

Best Regards,

Zhengdong Xu

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