Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Dear Experts,
I wish to calculate a % of total value within a group. This percentage should also be updated based on slicers on the report.
I wish to see a split of percentage based on advance orders.
Hi @lalTel20
please try
% Of Total Vol =
SUMX (
VALUES ( 'DCM Data'[ADVANCE Orders] ),
CALCULATE (
VAR curr = [Vol]
VAR base =
CALCULATE ( [Vol], REMOVEFILTERS ( 'DCM Data'[ADVANCE Orders] ) )
RETURN
DIVIDE ( curr, base )
)
)
Hi,
I am not sure how the datamodel looks like, but please try the below if it suits.
% Of Total Vol =
VAR curr = [Vol]
VAR base =
CALCULATE ( [Vol], ALLSELECTED ( 'DCM Data'[ADVANCE Orders] ) )
RETURN
DIVIDE ( curr, base )
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.
User | Count |
---|---|
42 | |
28 | |
24 | |
20 | |
16 |
User | Count |
---|---|
54 | |
35 | |
18 | |
18 | |
15 |