Show if between 2 values

[android1]

Hi,

I have the following measure Act Hrs % = DIVIDE(SUM(vw_PivotOTIF[Actual Hrs]),SUM(vw_PivotOTIF[Sched Hrs]))

which returns % values of the column [Actual Hrs].

I want to show all values >= 80 but less than 100. How would I do this? 

Thanks,

Gerry

[Vvelarde · Accepted solution]

@android1

Hi, you can obtain this using Filter Visual

[Vvelarde · Accepted solution]

@android1

Hi, you can obtain this using Filter Visual

[android1 · Accepted solution]

Hi,

Thanks for the reply. I reworked my other formulas & can do what I need now.

Thanks,

Gerry