cancel
Showing results for
Did you mean:
Frequent Visitor

## How to show percentage of total

I have a table containing sold shoes by customer. How do I visualize the sold shoes per sex as a percentage of the total order?

So the nominator = total order quantity per sex

and the denominator = total order quantity

 Orderno Itemnr OrderQuantity Clientno Sex 100 A 4 10359 Girl 101 B 5 10160 Girl 101 C 6 10160 Boy 101 D 1 10160 Boy 102 A 2 10175 Girl
1 ACCEPTED SOLUTION
Super User

Expected result: =
VAR orderspersex =
CALCULATE ( SUM ( Data[OrderQuantity] ), ALLEXCEPT ( Data, Data[Sex] ) )
VAR ordersall =
CALCULATE ( SUM ( Data[OrderQuantity] ), REMOVEFILTERS () )
RETURN
DIVIDE ( orderspersex, ordersall )

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

3 REPLIES 3
Frequent Visitor

Many thanks!

Super User

Expected result: =
VAR orderspersex =
CALCULATE ( SUM ( Data[OrderQuantity] ), ALLEXCEPT ( Data, Data[Sex] ) )
VAR ordersall =
CALCULATE ( SUM ( Data[OrderQuantity] ), REMOVEFILTERS () )
RETURN
DIVIDE ( orderspersex, ordersall )

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

Super User

@PaulusB , these measures can help

divide(sum(Table[OrderQuantity]), calculate(sum(Table[OrderQuantity]), allselected()))

divide(sumX(filter(Table, table[Sex] ="Girl"), Table[OrderQuantity]), calculate(sum(Table[OrderQuantity]), allselected()))

divide(sumX(filter(Table, table[Sex] ="Boy"), Table[OrderQuantity]), calculate(sum(Table[OrderQuantity]), allselected()))

Announcements

#### 2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

#### Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

#### Business Application LATAM Summit 2023

Join the biggest FREE Business Applications Event in LATAM this February.

#### Global Power Platform Bootcamp

In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.

Top Solution Authors
Top Kudoed Authors