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 in Power BI by Anitha
813 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 by Cherukuri
• 21,390 points

Related Questions In Power BI

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 in Power BI by Upasana
• 8,530 points
44 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 in Power BI by Shubham
• 13,290 points
76 views
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 2 days ago in Power BI by anonymous
• 21,390 points
15 views
0 votes
1 answer

To Calculate the Standard Deviation in Power BI

Suppose you've to obtain the Standard Deviation ...READ MORE

answered Nov 26, 2018 in Power BI by Upasana
• 8,530 points
1,424 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,100 points

edited Oct 11, 2018 by Kalgi 143 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
• 39,330 points
69 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 in Power BI by VNK
6,732 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
• 39,330 points
5,077 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 in Power BI by Cherukuri
• 21,390 points
73 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 in Power BI by anonymous
• 21,390 points
23 views