Colums Calculate

[pakovic]

Hi, I have this table in powerbi desktop and I would like to be able to display the data like this.
I have tried to use the filter function, but I get an error. is it possible to represent the table in powerbi in this way?

Attached pbix file

https://drive.google.com/file/d/1LlMuKwrs2JKNo0c0V4IfQtzKLn9pxEM5/view?usp=sharing

[Tahreem24 · Accepted solution]

@pakovic YOu should create a Measure like below:

Measure 2 = CALCULATE(SUM('Table'[Amount Cost]),ALLSELECTED('Table'[Type]))

[pakovic]

Ok, you've given me a hint... the correct function maybe would be:

Measure 2 = CALCULATE([Amount Cost];ALLSELECTED(Sales[Product]))

Thank you very much!!!