Messure - Tooltips

[MIKR0606]

Hi 

I am new to DAX and POWERBI. 

I would like to make a messure fore the tooltips, when i hoover over ex. Juni, which shows an incline in custom duty, which has to be paid. When you hoover over Juni, should show if possible, the 3 or 5 higest values from Customs duty table and item name.

Customs duty, is calculated ((Amount*Duty1%)+(Amount*Duty2)+((Quantity*Net weight)*Duty)))

Ex attached, amout is fictive

Hope some body have the time to help og guide me in the right way, 

Item numberProduct nameDuty1 %Duty2 %DutyQuantityAmountGross WeightNet WeightCalculated duty2 1006340-T1 HONEY 450 GR 15.87 OZ 17,30% 0,00% 0,00 0 0 0,00 0,00 0,00 1048348-T1 TUNA SHREDDED IN SOYA OIL 170 GR CANNED 24,00% 0,00% 0,00 0,00 665,00 0,00 0,00 159,60 1121734-T1 BEEF CUBE ROLL/RIB EYE WHOLE EX-CHILLED FROZEN 12,80% 0,00% 22,62 0,00 784,00 0,00 0,00 100,35 1459060-T1 CHICKEN WHOLE WITHOUT GIBLETS (GRILLER) 1.2 - 1.6 KG FROZEN 0,00% 0,00% 2,22 0,00 839,00 0,00 0,00 0,00 1047657-T1 CHICKEN WHOLE WITHOUT GIBLETS (GRILLER) 1.1 KG FROZEN 0,00% 0,00% 2,42 0,00 641,00 0,00 0,00 0,00 1010556-T1 TILAPIA WHOLE 300 - 500 GR FROZEN 8,00% 0,00% 0,00 0,00 269,00 0,00 0,00 21,52 1010466-T1 SNAPPER RED WHOLE FROZEN 15,00% 0,00% 0,00 0,00 267,00 0,00 0,00 40,05 1464583-T1 BEANS MUNG YELLOW SPLIT DRIED (MOONG DAL) 1 KG 2.2 LB 0,00% 0,00% 0,00 0,00 929,00 0,00 0,00 0,00 1109764-T1 CUMIN POWDER 1 KG 0,00% 0,00% 0,00 0,00 760,00 0,00 0,00 0,00 1047955-T1 LAMB MEAT PIECES W/ BONE SALT CURED NORWEGIAN TYPE FROZEN 12,80% 0,00% 0,00 0,00 654,00 0,00 0,00 83,71

[christinepayton]

Yes, you can use custom tooltips for this. Add another hidden report tab that is smaller in size and designated as a tooltip page. Then add a table to the page. You can add your fields to the table, sort it by the thing you're measuring, and optionally limit it to 3 rows with a Top N visual-level filter. Make sure your original chart is set to use the custom tooltip in visual settings. https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-tooltips?tabs=powerbi-desktop