SSAS Measure - How to do a Distinct Count using more than 1 column????

• mashadaG

  SSC Veteran

  Points: 269

  More actions

  June 23, 2011 at 10:46 am

  #240464

  I am new to SSAS and I am looking into generating a measure for a fact table as below.

  Customer IDOrder IDProcessed

  A1Y

  A2Y

  B3N

  C4Y

  E5Y

  E6Y

  E7N

  I would like to get the number of:

  1.Customers: = 4 (A,B,C,E)

  2.Customers with processed orders: = 3 (A,C,E)

  So far I can do DISTINCT COUNT on Customer ID, but how can I do a DISTINCT COUNT that also takes into account the processed field? In SQL I know I would be saying “WHERE processed = Y| N” as appropriate, but how would I go about this in SSAS measures?

  Any help will be greatly appreciated.

• CarpenterBob

  Ten Centuries

  Points: 1026

  More actions

  June 23, 2011 at 1:44 pm

  #1343365

  Gotta create an account if you dont have one, but this webinar will show you.

  http://cms.pragmaticworks.com/videos/default.aspx?VidID=464fe4c05f664a108d7ab7515a96c320

• mashadaG

  SSC Veteran

  Points: 269

  More actions

  June 25, 2011 at 5:51 am

  #1344071

  Thanks for that, I have gone through the webinar and learnt a bit more, but I am still not sure how to get the DISTINCTCOUNT on a filtered measure.

  Any help will be greatly appreciated.