Forum Discussion
Anonymous
5 years agoNot applicable
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...
- 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
5 years agoSuper User
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