Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

SPD share Calculation

 i have table name called Master DB .  My table  data looks like the below .   Category Dec             Market name            Actuals  Cigarettes                    AZ                            ...
Help appreciated
Help me
Help Requested
  • amitchandak's avatar
    amitchandak
    4 years ago

    Anonymous ,

    That will be

    New measure =

    var _cat = CALCULATE ( SUM ( 'Master DB'[Actuals] ), 'Master DB'[Category Dec] = max( 'Master DB'[Category Dec] ) )

    var _self = SUM ( 'Master DB'[Actuals] )

    return

    divide(_cat -_self,_cat)

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Anonymous , Not able get that 100 -500/100

 

but need be like

 

SPD SHARE =

VAR selectedSPD =
SELECTEDVALUE
VAR totalsum =
CALCULATE ( SUM ( 'Master DB'[Actuals] ), ALL ( 'Master DB' ) )
VAR _select_cat =
CALCULATE ( SUM ( 'Master DB'[Actuals] ), 'Master DB'[Category Dec] = max( 'Master DB'[Category Dec] ) )
VAR _select_mar =
CALCULATE ( SUM ( 'Master DB'[Actuals] ), 'Master DB'[ Market name] = max( 'Master DB'[ Market name] ) )
RETURN
DIVIDE ( ( _select_cat - _select_mar ), totalsum )