Monthly share tooltip

[Anonymous]

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,

[parry2k]

@Anonymous anyhow you already have the solution but in the future read this post to get your answer quickly.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[parry2k]

@Anonymous and what is company measure?

[Anonymous]

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

[parry2k]

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

[BA_Pete · Accepted solution]

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