Custom tooltip for matrix : Level of detail calculation

[Anonymous]

Hi,

I have an issue which I suspect would required level of detail calculation similar to that of tableau).

Im new to powerbi and not sure how to use it.

Here is the problem statement : 

Dataset : 

From the above table I have created a matrix in power bi which looks like this : 

My question : 

I have created a custom tooltip which displays median profit

However I want to show median opacc not at the item level but at the configuration level i.e when I scroll on any item within the same row(config id) i should get a single median profit. And that should be the median profit for the config id

Please help

[v-jiascu-msft · Accepted solution]

Hi @Anonymous,

Add a measure to the Tooltip and you will get the result. 

Measure =
CALCULATE (
    MEDIAN ( Table1[Total Profit] ),
    ALLEXCEPT ( Table1, Table1[Config ID] )
)

Best Regards,