list reports with calculated percentage in Power BI using dax

Question

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

Answer 1

Create a Measure called Total Revenue:

Total Revenue = 
SUMX(
    CALCULATETABLE(
        'vw_PandL',
        'vw_PandL'[Line] = "Total Revenue"
    ),
    [MTH]
)

Create another Measure called %:

% = VALUES(vw_PandL[MTH]) / [Total Revenue]

And it will work with filters applied.

When creating reports that include calculated percentages using DAX, it’s important to also consider how these reports will appear on different screen sizes and devices. A common issue users encounter is that Power BI visuals do not resize properly, leading to misaligned or cropped visuals when viewed on smaller screens, external monitors, or mobile devices.

Preparing for Power BI exam? Check out Power BI Syllabus now!