Measure with filter

[former_member729889]

Hi,

I want to filter a measure by using an existing filter in the universe.

My filter is like this:

DateUser:

@Select(Sales\Calendar Day) =  @Prompt('Date:','D',,Mono,)

What I want to do is to create a measure by using this filter.

SUM

(

CASE

   WHEN DP_Sales.CalendarDay >=

    TRUNC (@Where(DateUser),'mm')

    AND DP_Sales.CalendarDay <

    TRUNC (@Where(DateUser))+1

   THEN DP_Sales.Value

END

)

This gives an error like : "Syntax error : expected something between ')' and '='.

If I write a prompt (@Prompt('Date:','D',,Mono,Free)) instead of @Where(DateUser) it work as expected.

How can I use an existing filter instead of writing prompts again?

Thank you!

[former_member729889]

Anyone?

[Former Member]

Hi Steve,

We are on BI 4.1 SP2 and I could see the same happen on our environment. But when I add the condition to a where clause of a dimension and use it in the measure sing Former Member, it works as expected. Looks like a bug to me.

Cheers

Mohan