My Fact table has units sold and 4 different addon units sold. I have written the measures to calculate for each of the 4 Addon types the penetration stat (Addon unit sold / Units Sold). Easy enough as well to expand this for MTD/YTD/LYTD and Budget.
It’s easy enough to get these measures onto cards or Kpi visuals, but I’d just like to put them onto a matrix visual but can’t seem to do so. Ideally I’d like a matrix view looking like this:
Columns across – ActMTD Act YTD etc
Addon Penetration (product1)
Addon Penetration (product2)