cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper II

## How to do percentage

I would like to see the percentage of each BU (APP, HW,FW)

I dont know what dax function to use,, I need the sum of APP divide each of the APP  etc.. ( sum of Brand A / each Brand)

and i need to add 3 filter. while i click it automalitly show the percentage.

Below will show Brand, Department etc.

Here is one of the filter i would like to show.

1 ACCEPTED SOLUTION
Super User

@tyan , for % of Grand totalof a measure , we will use

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

for % of Sub Total

divide([measure], calculate([measure], removefilters(Table[Brand]))

divide([measure], calculate([measure], filters(allselected(Table) , Table[Department] max(Table[Department] ) ))

Percent of SubTotal or Total: https://www.youtube.com/watch?v=6jTildcV2ho&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=37

2 REPLIES 2
Super User

@tyan , for % of Grand totalof a measure , we will use

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

for % of Sub Total

divide([measure], calculate([measure], removefilters(Table[Brand]))

divide([measure], calculate([measure], filters(allselected(Table) , Table[Department] max(Table[Department] ) ))

Percent of SubTotal or Total: https://www.youtube.com/watch?v=6jTildcV2ho&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=37

Helper II

@amitchandak thank you so much for helping me!

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - June 2024

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

#### Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors
Top Kudoed Authors