How to calculate cumulative Total and % in DAX?

0 votes

How to calculate cumulative Total and % in DAX in Power BI? I want cumulative for each column after each row for a country along with original rows. can someone help me?

Mar 18, 2019 in Power BI by Anitha
9,364 views

1 answer to this question.

0 votes

Hi,

If your table is ready with percentage field and measure column for performing cumulative total, then follow below steps.

1. Select the sheet you want to apply cumulative total.

 

2. Click on New Quick Measure. Then a dialog box opens, click on running total and select the column ( field ).

3. Click on Ok and Dax code shows up, rename the measure name and click on tick button.

4. Then add the field into the table values.

5. The cumulative total is shown as required now.

Follow the same procedure with % column, the percentage will be given as running total.

Hope this helps you.

answered Mar 18, 2019 by Cherukuri
• 32,490 points

Related Questions In Power BI

0 votes
1 answer
0 votes
1 answer

How DAX Difference between naked SUM and sum wrapped in CALCULATE?

This is materially different than the question ...READ MORE

answered Oct 8 in Power BI by Gitika
• 42,520 points
17 views
0 votes
1 answer

How to Transpose unique values and get matching values in rows?

I think this query should do what ...READ MORE

answered Apr 1, 2019 in Power BI by Upasana
• 8,620 points
475 views
0 votes
1 answer

To calculate conditional running total in power query

Try Table Buffer after adding the index, or ...READ MORE

answered Apr 26, 2019 in Power BI by Shubham
• 13,450 points
955 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 673 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
• 51,970 points
267 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 22, 2019 in Power BI by VNK
15,494 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
• 51,970 points
23,871 views
0 votes
1 answer

How to show filtered vs total data in power BI?

Hi sindhu, Follow below steps to show filtered ...READ MORE

answered Mar 26, 2019 in Power BI by Cherukuri
• 32,490 points
611 views
0 votes
1 answer

How to categorize state, pin and city in power bi (Address)

After loading dataset, you can split in ...READ MORE

answered May 9, 2019 in Power BI by anonymous
• 32,490 points
557 views