Show Non-aggregated value on tooltip in Matrix

[ChristaAlen]

AI am trying to show Non-aggregated value on tooltip in Matrix. My Data table is :

 

For example if I hover over "AValue" the tooltip should take the value of Table[product3] where Table[Hierarchy 5] == "AValue". So with the table above I wanted to show `2` on tooltip when hovering on AValue in matrix. But its showing total of  2+1+3+5, which is 11

Is there any way to achieve this result. Any help is appreciated.

[NoWayNearNerd]

Did you find any solution?
I am also looking for same.

[amitchandak]

@ChristaAlen , Not very clear. But you can create a tooltip. In tooltip page, You can uncheck keep all filter and drop the only filter you want to pass (page property of tooltip page)

https://docs.microsoft.com/en-us/power-bi/desktop-tooltips

[ChristaAlen]

Thank You for your reply. To make it more clear, I have removed the tooltip and added it as column (product3)  in the below matrix. 

 

Currently it is showing the sum of Product3 values for each row. But what I actually wanted is shown to the right. (ie instead of 11.00 in the first row I wanted to show 2.00, instead of 9.00 in 5th row I wanted to show 1.00).

product3 column in the matrix can be calculated as follows:

1. See what value is shown in the leftmost column of matrix. (For example lets take 1st row, left most column value is "AValue")

2. Now filter the table with [Hierarchy 5] equals to this value. (table[Hierarchy 5] == "AValue")

3. Get the value of product3 column from this filtered table (table[product3] value is 2)

I am struggling to come up with a measure to represent the above logic. It looks very straight forward but I am not able to figure it out.