Forum Discussion
SPD share Calculation
i have table name called Master DB . My table data looks like the below . Category Dec Market name Actuals Cigarettes AZ ...
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 sir i am getting Failed to resolve name 'SELECTEDVALUE'. It is not a valid table, variable, or function name error