How To Filtrate a list in String with MDX

• akirajt

  Right there with Babe

  Points: 762

  More actions

  December 6, 2013 at 9:20 am

  #395953

  Goal:

  Filtrate the value in the table column based on Canada as a criteria.

  Problem:

  I cannot get the MDX syntax code in where state to be correct in order to filtrate the based on "Canada".

  Information:

  *This situation is a simplified sample and my request is to add filtration criteria in the where state.

  *Data source is SSAS:s AdvecntureWorksDW2012

• PB_BI

  SSCoach

  Points: 17463

  More actions

  December 9, 2013 at 9:32 am

  #1672024

  You don't need to use FILTER here. This would suffice:

  select

  {[Measures].[Reseller Order Count],[Measures].[Discount Amount]} ON 0,

  {[Reseller].[Reseller Type].[Business Type].Allmembers} on 1

  FROM

  [Adventure Works]

  WHERE

  [Geography].[Country].&[Canada]

  ---

  I'm on LinkedIn