calculate the share value

Question

Hi all,&nbsp;i&nbsp; have a&nbsp; table like&nbsp; below (sample data)&nbsp;&nbsp; SPDDESC&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;ACTvalue&nbsp;&nbsp;BOX 20&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1000MNT&nbsp; 20&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;500RED 20&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;600&nbsp;i having like&nbsp; around 50 SPD Desc .&nbsp; i want calculate&nbsp; SPD share for individual share&nbsp;&nbsp;&nbsp;for Example if i choose KSBOX20&nbsp; desc&nbsp;&nbsp;calculation should be&nbsp;&nbsp;&nbsp;SPD share =&nbsp;&nbsp;(BOX 20 -ACTvaluetoal)/BOX20&nbsp;&nbsp;&nbsp;SPD share =&nbsp;&nbsp;(1000 -2100)/1000.&nbsp;&nbsp;i want to set this formula for all SPDDESC&nbsp; &nbsp; . any idea. i have tired selected value function&nbsp; but&nbsp; not work. thanks in advance&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

samarth_18 · Accepted Answer

Hi&nbsp;Anonymous&nbsp;,&nbsp;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 )&nbsp;Output:-Thanks,Samarth&nbsp;

Forum Discussion

calculate the share value

2 Replies

Related content

DAX for calculating retroactive values

PowerBI - Matrix table, hide values used only for a visual calculation

Report Sharing

Total value missing in calculated column

Commitment value calculating incorrectly - DAX Logic