How to make tooltips

[HUAM]

Hi all,

I want to make tooltips by adding additional parts "Portion"

Two Value are the measure value like below;

#Off_MGM =

var Last_Month = IF(MONTH(today()) = 1, DATE(YEAR(TODAY())-1, 12, 1), DATE(Year(today()), Month(TODAY())-1, 1))

return

CALCULATE(COUNTROWS('table'),

'table'[channel] = "Offline",

'table'[coupon_status] = "Use",

'table'[transdate]<= TODAY()-1 && 'table'[transdate] >= Last_Month)

I think I have to make a measure value for tooltips

But I don't have any idea.

please help me

Thank you.

[v-shex-msft]

Hi @HUAM,

Can you please share some dummy data that keep raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng

[amitchandak]

@HUAM , try a measure like this

calculate(CALCULATE(COUNTROWS('table')), CALCULATE(COUNTROWS('table'), removefilters('table'[channel])))

Percent of SubTotal or Total: https://www.youtube.com/watch?v=6jTildcV2ho&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=37

[HUAM]

Thank you.

I tried 

DIVIDE(CALCULATE(COUNTROWS('table')),

CALCULATE(COUNTROWS('table'),

REMOVEFILTERS('table'[channel])))

but it isn't work. Both online and offline results are 1.

The channel contains other things besides online and offline.

And also I want to know that If two measurements are made from different tables, how to calculate them.

Actually, I actually don't know much about funtion(selectedmeasure),

but I hope that if you mouse over to a certain measure value, the ratio results will come out.

So i tried like below..

IF(SELECTEDMEASURE() = [#Online], DIVIDE([#Online], [#Online]+[#Offline]),

IF(SELECTEDMEASURE() = [#Offline], DIVIDE([#Offline],[#Online]+[#Offline]))

)