none
Creating a Calculated measure based on the dimensions RRS feed

  • Question

  • Hi

    I want to create a calculated measure based on the dimensions.

    I've a measure named Called and dimensions - Territory, Customer,sector and calendar Month.

    Whenever user selects these dimensions then the new calculated measure should display 1 if the main measure have value atleast 1 otherwise 0.

    Please help in writing this calculated measure.

    Thanks in advance

    --Noor

    Friday, July 20, 2012 6:50 AM

Answers

  • Hi Noor,

    Can you please provide more details? What do you mean "when users select these dimensions"? If you create a calculated member based on the Measure, it would work with all the dimensions that your original Measure would work with.

    Try using something like below:

    IIF(IsEmpty([Measures].[Called]), 0,1)

    Where Called is the name of your Measure. Hope this helps!


    Shahfaisal Muhammed http://shahfaisalmuhammed.blogspot.com

    • Marked as answer by SQL2012BI Monday, July 23, 2012 4:04 AM
    Friday, July 20, 2012 1:58 PM

All replies

  • Hi Noor,

    Can you please provide more details? What do you mean "when users select these dimensions"? If you create a calculated member based on the Measure, it would work with all the dimensions that your original Measure would work with.

    Try using something like below:

    IIF(IsEmpty([Measures].[Called]), 0,1)

    Where Called is the name of your Measure. Hope this helps!


    Shahfaisal Muhammed http://shahfaisalmuhammed.blogspot.com

    • Marked as answer by SQL2012BI Monday, July 23, 2012 4:04 AM
    Friday, July 20, 2012 1:58 PM
  • Thanks a lot for the help.
    Monday, July 23, 2012 4:05 AM