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
```
Oct 22, 2018 in Power BI 1,504 views

## 1 answer to this question.

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.

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

• 18,580 points

## How to rename a column using DAX in Power BI?

Hi Ramya, I found these two function that ...READ MORE

## After connecting SharePoint List with Power BI, and editing data in query, all the data I want are in links

I've try so many ways to decode ...READ MORE

## Calculate GB Using DAX in Power BI

Hi, @Vnk You can go through this regarding ...READ MORE

## Using DAX calculation how to calculate monthly budget till today in power bi Desktop?

You can make use of this: MTD Budget ...READ MORE

## Combine tables in Power BI

You can also achieve this using a ...READ MORE

## Power Bi Dax Table

You need to wrap the numbers in ...READ MORE

## Power BI Dax Multiple IF AND Statements

HI I have Column Patient 12 13 14 15 18 IN Patient=12, 13 Out ...READ MORE

## Distinct count filtered by condition using Power BI Dax

Try this, it should work: DistinctCountActiveMonths = CALCULATE( ...READ MORE