list reports with calculated percentage in Power BI using dax

0 votes

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 by shubham
• 7,340 points
1,638 views

1 answer to this question.

0 votes

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!

answered Oct 22, 2018 by Hannah
• 18,520 points

Related Questions In Power BI

0 votes
1 answer

How to rename a column using DAX in Power BI?

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

answered Aug 22, 2019 in Power BI by anonymous
• 33,030 points

edited Dec 31, 2021 by Soumya 37,120 views
0 votes
0 answers

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

Jun 18, 2020 in Power BI by Dora
• 120 points
1,182 views
0 votes
1 answer

Calculate GB Using DAX in Power BI

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

answered Jun 30, 2020 in Power BI by Gitika
• 65,770 points
4,765 views
0 votes
1 answer

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

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

answered Sep 24, 2020 in Power BI by Gitika
• 65,770 points
1,853 views
+3 votes
2 answers

Combine tables in Power BI

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

answered Oct 5, 2018 in Power BI by lina
• 8,220 points

edited Oct 11, 2018 by Kalgi 2,480 views
0 votes
1 answer

Power Bi Dax Table

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

answered Oct 5, 2018 in Power BI by Kalgi
• 52,350 points
1,171 views
0 votes
2 answers

Power BI Dax Multiple IF AND Statements

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

answered May 23, 2019 in Power BI by VNK
18,959 views
0 votes
1 answer

Distinct count filtered by condition using Power BI Dax

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

answered Oct 5, 2018 in Power BI by Kalgi
• 52,350 points
37,671 views
0 votes
1 answer

How many reports can be created in one Power BI reports

You have a limit of 1000 datasets ...READ MORE

answered Sep 24, 2018 in Power BI by Hannah
• 18,520 points
1,665 views
+1 vote
1 answer

Have column with multiple values in powerBI, for use with a slicer in power bi

It can be achieved depending on the result you ...READ MORE

answered Oct 22, 2018 in Power BI by Hannah
• 18,520 points
7,478 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP