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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

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!

## Helpful resources

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.

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors
Top Kudoed Authors