percent of total in a group with external filters

[Anonymous]

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. 

% Of Total Vol =

VAR curr = [Vol]

var base = CALCULATE([Vol], REMOVEFILTERS('DCM Data'[ADVANCE Orders]))

RETURN

DIVIDE ( curr, base )

//COMBINEVALUES(",", curr, base).
However, the totals do not add up .  Any help would be appreciated. 

Thanks,

Lalit

[tamerj1]

Hi @Anonymous 

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 )
    )
)

[Jihwan_Kim]

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 )