Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 |
Solved! Go to Solution.
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.
Many thanks!
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.
@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()))
User | Count |
---|---|
42 | |
28 | |
23 | |
18 | |
16 |
User | Count |
---|---|
54 | |
35 | |
18 | |
18 | |
15 |