Dax help: Shadow context with allselected()

• pietlinden

  SSC Guru

  Points: 63621

  More actions

  September 12, 2020 at 7:55 pm

  #3788105

  I created this measure using the allselected function.

  Could you post the code for it? Something like

  DIVIDE ( [Total Sales], CALCULATE([Total Sales], ALLSELECTED('Calendar'[Month]))

• Lidou123

  Hall of Fame

  Points: 3186

  More actions

  September 12, 2020 at 9:45 pm

  #3788111

  Hello

  Thanks for your help.

  The first measure is ExpoWeight_PTF.

  This measure works well.

  But there is another measure which used the first measure. And the second measure have wrong result because of the shadow context of AllSelected function. Do you know how to work around this shadow context issue ?

  CT_Zspread_PTF
  
  SUMX('Position',[ExpoWeight_PTF] * related('Security'[SEC_Zspread]))

   

  ExpoWeight_PTF = VAR CurrentExposureVal = [SEC_Exposure_PTF]
  VAR ParentAssetVal =
  
  CALCULATE([SEC_MarketValue_PTF], ALLSELECTED()) 
  
  RETURN
  
  DIVIDE (CurrentExposureVal, ParentAssetVal)

• Lidou123

  Hall of Fame

  Points: 3186

  More actions

  September 12, 2020 at 9:45 pm

  #3788112

  Hello

  Thanks for your help.

  The first measure is ExpoWeight_PTF.

  This measure works well.

  But there is another measure which used the first measure. And the second measure have wrong result because of the shadow context of AllSelected function. Do you know how to work around this shadow context issue ?

  CT_Zspread_PTF
  
  SUMX('Position',[ExpoWeight_PTF] * related('Security'[SEC_Zspread]))

   

  ExpoWeight_PTF = VAR CurrentExposureVal = [SEC_Exposure_PTF]
  VAR ParentAssetVal =
  
  CALCULATE([SEC_MarketValue_PTF], ALLSELECTED()) 
  
  RETURN
  
  DIVIDE (CurrentExposureVal, ParentAssetVal)