need help: how to calculate measure then display it into the table and bar chart power bi

[Cardi0z]

Dear All,

below i have attached sample data. need help how to calculate the measure, then display it into the table and bar chart on power bi? this is a little complicated, because the results must be exactly the same. I need logic to calculate it and I still haven't got it.


link:
Sample data 

Thank you

CC :
@v-yilong-msft
@v-huijiey-msft 
@v-yangliu-msft 
@v-rzhou-msft 
@Anonymous 

[Cardi0z]

Dear @amitchandak 

1. below is the data source

2. I want to visualize a report data table in power BI with values ​​taken from the data source. below is the screnshoot (table 1)

the header name and column "Type" must be the same as the screenshoot above

3. next, i want to create the table data in power bi (table 2), with value from category. below is the screenshoot.

the header name and column "Category" must be the same as the screenshoot above

4. next, i want to create bar chart, with value base on "Tabel 2".  below is the screenshoot.

the legend name is "Liquid", "Solid", and "Total". to make it easier to understand, I have included an attachment below:

https://docs.google.com/spreadsheets/d/15T8QHhxz6mF4qRl9y91qLg6ovCwLR1Dy/edit?usp=drivesdk&ouid=1095... 

i hope you can help me how to solve the problem.
thank you.

[amitchandak]

@Cardi0z , what is the measure calculation you need?

The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.

[Cardi0z]

@amitchandak 

halo, can you help me?