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
NewbieJono
Post Patron
Post Patron

Percentage

Hello All, i want to show the percentage split per month from the Legend Path. e.g i need July to show approx 86% Fully Digital and 14% Manual. Any ideas what DAX i use. the only drop down option on volume i have is Percentage of grand total, which does not seem to work.

 

Capture2.PNG

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@NewbieJono , You need to have a measure like, assume Volumn is column

 

divide(Sum(Table[Volumn]), calculate(Sum(Table[Volumn]),removefilters(Table[Path])) )

View solution in original post

1 REPLY 1
amitchandak
Super User
Super User

@NewbieJono , You need to have a measure like, assume Volumn is column

 

divide(Sum(Table[Volumn]), calculate(Sum(Table[Volumn]),removefilters(Table[Path])) )

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.