Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

How to make tooltips

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.

 

Need Help

3 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      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]))
      )
  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Anonymous,

    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