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
Super User
Super UserAnonymous ,
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 let me try and will update now sir