I have a Power BI report with multiple lines (it's a P and L report) displayed in a list visualisation.
It's populated from a view in SQL
One of the lines is 'Total Revenue'
I need every line to display its proportion of Total Revenue as a percentage:
i.e.
LINE MTH %
------------------------
Line1 5 10
Total Revenue 50 100
Line2 20 40
Line3 4 8
Line4 12 24
Note that MTH does not add up to total revenue so I can't just take the total, I need to take the line called Total Revenue as the denominator