Find median of different categories

[SteveIOW]

Hi all,

I'm sure this must be really easy but I am... stuck... sorry.

I have a dataset with a value per customer.

Customers can be split into different Peer categories, and a customer can appear in more than one category.

I need to find the median value of each category per customer.

I've tried a couple of methods and all give me the same result - see screenshot below, all of which are for one single customer.

Obviously the median for each category should be different...

Thanks for taking the time to look at this.

best

Steve

[lbendlin]

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...