topic Re: calculate the share value in DAX Commands and Tips

calculate the share value

Anonymous — Fri, 10 Dec 2021 09:10:08 GMT

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

Re: calculate the share value

Samarth_18 — Thu, 09 Dec 2021 13:06:04 GMT

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

Re: calculate the share value

Anonymous — Thu, 09 Dec 2021 13:16:06 GMT

Samarth_18 Thank you so much