Using expression for value in Count Measure's Filter

[JCardoza]

Hi,

I want to create a Count Measure for my Business Scenario and in the Filter have an attribute whose value needs to be an expression and not just a simple value.

For example:

Instead of the following:

I would like to have something like:

Can someone please guide me on how to achieve this?

Regards,

JC

[p1024029 · Accepted solution]

Hi JC,

You may need to create additional calculated column of type measure in calculation view which bound to your data sourrce and import that in OpInt measures.

Regards,

Naresh

[Archana · Accepted solution]

Hello JC,

For normal Count or Duration measure you cannot create expressions. For that you have to create a custom SUM measure in context calculation view based out of your tables and use that measure in business scenario using 'Import' option in the Measure folder.

Note: If you create the custom measure in another calculation view apart from context calculation view then you have to create an analytical privilege and add that to your user, otherwise the generation would fail. 

Hope this helps.

Regards,

Archana