Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Monthly share tooltip

Hi, I have this chart

 

I need to create a measure to put in the tooltip section. I need that ratio to be : Company / Total Market by Month. So if I check the Tooltip in 2019-02, the Share Company will be 45% (33617 / 74121)

 

In the image I've put the "Company" measure in the tooltip as % of grand total but the number is not right for the month.

 

Thanks

 

Thanks,

Need Help
  • BA_Pete's avatar
    BA_Pete
    5 years ago

    Hi Anonymous ,

     

    Apologies if I'm misunderstanding your requirement, but have you tried creating a measure like this:

     

    _shareCompany = DIVIDE([CompanyCalc], [totalMarketCalc], 0)

     

     

    As your Total Market and Company calculations appear to be displaying correctly by month, then it should just be a simple divide operation, no?

     

    Pete

5 Replies

  • BA_Pete's avatar
    BA_Pete
    Super User
    5 years ago

    Hi Anonymous ,

     

    Apologies if I'm misunderstanding your requirement, but have you tried creating a measure like this:

     

    _shareCompany = DIVIDE([CompanyCalc], [totalMarketCalc], 0)

     

     

    As your Total Market and Company calculations appear to be displaying correctly by month, then it should just be a simple divide operation, no?

     

    Pete

  • parry2k's avatar
    parry2k
    Super User
    5 years ago

    Anonymous Do you have a date dimension in your model that you are using on x-axis?

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi,

      Company = 

      CALCULATE(SUM(Unidades_AllDetail[Unidades]),FILTER(Unidades_AllDetail,Unidades_AllDetail[Laboratorio]={"ELE"}))
       
      I have a date dimension in the same table as Unidades