Add Multiple calculated columns in matrix without creating the column hierarchy

[Rupali_Namdeo]

Hello All,

I have some data and want to create a report based on Region and Employee hierarchy. All the column data needs to calculated and needs to add dynamically. It should be in the below format. Is there any way to achieve it?

Thanks,

[v-lionel-msft]

Hi @Rupali_Namdeo ,

I'm not sure what your data model looks like?
Which columns are calculated columns? What does it mean to be dynamically added to the matrix? Please explain in details.

Best regards,
Lionel Chen

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

[lbendlin]

https://community.powerbi.com/t5/Community-Blog/Creating-a-custom-or-hybrid-matrix-in-PowerBI/ba-p/1...