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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
blockobito
Helper I
Helper I

Percentage Total

Hello, 

I have this Number Text which is a %GT count of Data and a donut chart related to that %GT Count of Data

when i click a part of Donut Chart. Number Text doesnt follow the percentage. 

 

any tips?

THank You! 

1 REPLY 1
amitchandak
Super User
Super User

@blockobito , Not very clear, but that will filter % of the total. If you do  want % the total not to consider filter

assume you have measure M1

 

Then

% of total =  divide([M1], calculate([M1], all()) )

 

 

or with selected values

 

% of total =  divide([M1], calculate([M1], allselected()) )

 

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

Helpful resources

Announcements
PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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