calculate the share value

[Anonymous]

Hi all,

i  have a  table like  below (sample data)

  SPDDESC                                                                           ACTvalue

 BOX 20                                                                            1000

MNT  20                                                                     500

RED 20                                                                 600

i having like  around 50 SPD Desc .  i want calculate  SPD share for individual share 

 for Example if i choose KSBOX20  desc 

 calculation should be 

SPD share =  (BOX 20 -ACTvaluetoal)/BOX20  

SPD share =  (1000 -2100)/1000.

 i want to set this formula for all SPDDESC    . any idea. i have tired selected value function  but  not work. thanks in advance 

[Anonymous]

@Samarth_18   Thank you so much

[Samarth_18 · Accepted solution]

Hi @Anonymous ,

You can try below code:-

SPD_share =
VAR selectedSPD =
    SELECTEDVALUE ( 'Table (3)'[SPDDESC] )
VAR totalsum =
    CALCULATE ( SUM ( 'Table (3)'[ACTvalue] ), ALL ( 'Table (3)' ) )
VAR selected_spddesc_value =
    CALCULATE ( SUM ( 'Table (3)'[ACTvalue] ), 'Table (3)'[SPDDESC] = selectedSPD )
RETURN
    DIVIDE ( ( selected_spddesc_value - totalsum ), selected_spddesc_value )

Output:-

Thanks,

Samarth