cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
leharkapil Member
Member

Custom tooltip for matrix : Level of detail calculation

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 : 

 

table.png

 

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

 

matrix.png

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

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Custom tooltip for matrix : Level of detail calculation

Hi @leharkapil,

 

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,

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 REPLY 1
Community Support Team
Community Support Team

Re: Custom tooltip for matrix : Level of detail calculation

Hi @leharkapil,

 

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,

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.