How to filter on a calculated measure? I need to filter on a % amount

[Karolina411]

Hello Daxters:

I need to take a calculated measure and extract out of it thoe % that are less then 50% , for example.

The Measure is a simple % calculation: 

%expected_1 = [Totaltime_1]/[TotalAVGMIN_1]

I need to take the RESULTS of this and show those results less than 50%, for example?

I am not comfortable yet w/ SummarizeTables so any advice is appreciated.  It has to be quite common.

In SQL it could be a Case /When statement.

[Ashish_Mathur]

Hi,

Expand the filter pane and give that filter condition.  Also, use the DIVIDE() function instead of the /

%expected_1 = DIVIDE([Totaltime_1],[TotalAVGMIN_1])

Hope this helps.