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
PoojaPandey
Frequent Visitor

% of grand total for count is changing after applying filter

Hello , 
I am new to power Bi learning and I am facing issue with my 1st project . Issue is my % grand total for count on X category is changing when i apply filter . Intial Bar Chart without filter

PoojaPandey_0-1701267504196.png

 

After I apply filter on "Discripancy status " and select "Error" . Then , the whole % changes as it's than only considering tptal of "Error" and ignoring count of "No error " . How do I fix this ? I have seen few articles but wasn't able to fix it . Any help with be highly appreciated 

PoojaPandey_1-1701267652983.png

 

 

1 ACCEPTED SOLUTION
swikritee_p
Resolver II
Resolver II

You are using a measure like for grand total (You can try using new  Measure driven data labels, if needed )

 

divide([measure], calculate([Measure], all()))

 

 

or

 

divide([measure], calculate([Measure], allselected()))

View solution in original post

2 REPLIES 2
PoojaPandey
Frequent Visitor

Thank you ! It worked . 

swikritee_p
Resolver II
Resolver II

You are using a measure like for grand total (You can try using new  Measure driven data labels, if needed )

 

divide([measure], calculate([Measure], all()))

 

 

or

 

divide([measure], calculate([Measure], allselected()))

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

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.