if you want to show value by total cost selected as filter then follow below step.
I have used sample super store data to show the details.
Then go the below option insert - Type Total cost and insert category name like below
then final output will be like below.
i am attaching the workbook for your reference. Please let me know if this is what u are looking for.
In sheet 2 I have used dynamice measure for your reference if you looking something like.
Please mark this answer correct answer and helpful if it solves your issue.
Example_v10.5.twbx 355.9 KB
I'm afraid that isn't really what I meant.
Using your example, let's say I didn't just have total cost and had several measures in a table:
What I would want is to Display those three measures with the category filtered, which I've mocked up below:
This is what I'm after, I've changed the alias in this mock up, which I don't think you can change dynamically to my knowledge.