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 Co...
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

parry2k's avatar
parry2k
Super User
5 years ago

Anonymous and what is company measure?

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