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 Not able get that 1000 -500/1000
For example 1000 - this is total value for selected Cigarettes category desc .
500 - selected market value .
let me use above your mentiond measure sir
- amitchandak
Super User
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 let me try and will update now sir