Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
msuser48
Helper I
Helper I

Change Running Total to percentage of population instead of a number

I have this table:

 

IdDateProductRunning Total
12017-01-0103
22018-01-0103
32019-01-0103
42017-01-0116
52020-01-0116
62021-01-0116
72021-01-0127
82022-01-0138
92022-01-0149
102017-01-01511
112022-01-01511

 

When I apply a filter to the date dimension from 2018-01-01 to 2022-01-01, I get this data:

 

IdDateProductRunning Total
22018-01-0102
32019-01-0102
52020-01-0114
62021-01-0114
72021-01-0125
82022-01-0136
92022-01-0147
112022-01-0158

 

"Running Total" is produced using this measure:

msuser48_0-1670240522701.png

If I want to have "Running Total" displayed as a percentage out of the measure "TotalPopulation" (which is just a whole number that changes dynamically when filters are applied), how do I achieve this?

 

Expected output when "TotalPopulation" Measure = 200:

IdDateProductRunning Total
22018-01-0101%
32019-01-0101%
52020-01-0112%
62021-01-0112%
72021-01-0122,5%
82022-01-0133%
92022-01-0143,5%
112022-01-0154%

 

 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@msuser48 , for % of the total divide it by

 

 

calculate(Countrows(Table), allselected(Table))

 

Percent of Total and Percent of SubTotal https://www.youtube.com/watch?v=6jTildcV2ho

View solution in original post

1 REPLY 1
amitchandak
Super User
Super User

@msuser48 , for % of the total divide it by

 

 

calculate(Countrows(Table), allselected(Table))

 

Percent of Total and Percent of SubTotal https://www.youtube.com/watch?v=6jTildcV2ho

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.