Post reply

MDX: SSRS Expression: Count Dimension members based on other Dimension

  • September 25, 2013 at 7:22 am

    #395546

    Hi there,

    I am pretty new to mdx expressions, and am currently trying to write a calculated member in SSRS (2012) that does pretty much the following:

    Dimension1 - CampaignNames

    Dimension2 - Customers

    Dimension3 - ContactDate

    now out of These three i want to see the Number(Count) of Customers that have been Contacted (for which there is a ContactDate, so basically where ContactDate is not Unknown or Null).

    Logicaly maybe something like this

    Count(Customers) where ContactDate NonEmpty

    ( I am not quite sure if i'm typing it correctly, this is just how i Thing it's done for now. i don't know if this would also exclude NULL Values.)

    I want this to be done Relative to the CampaignName though, so when i put it on a table later, i could Group by Campaign Name and then Customers.

  • September 25, 2013 at 11:51 am

    #1653293

    Just to clarify, are you looking to do this in a SSRS dataset containing an MDX query or within a table in SSRS.

    If it is the MDX route then please list out the dimension and measures you are using for this. Please show any code you have tried to perform this task.

    Fitz

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply