Wanted to help to show values in multiple aggregation which is comming from single column in matrix

[Shubham_Tekade]

Hello Guys,

I need help to create one table or matrix using below data-

And I wanted to show the values using some aggreation depend on conditions like below-

Anyone having expertise over this will help me to solve issue asap.

Thanks for your response.

-Shubham.

[Jihwan_Kim]

Hi,

One of ways is to create a dynamic format DAX formula like below.

Please check the below picture and the attached pbix file.

[Shubham_Tekade]

Hello @Jihwan_Kim ,

I got your solution but I am unable to implement same thing on my side.

Any suggestions on this.

Thanks for your solution.