cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Post Patron
Post Patron

Show if between 2 values

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

 

 

 

 

2 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted
Community Champion
Community Champion

@android1

 

Hi, you can obtain this using Filter Visual

 

Filter.png




Lima - Peru

View solution in original post

Highlighted

Hi,

 

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

 

Thanks,

 

Gerry

View solution in original post

2 REPLIES 2
Highlighted
Community Champion
Community Champion

@android1

 

Hi, you can obtain this using Filter Visual

 

Filter.png




Lima - Peru

View solution in original post

Highlighted

Hi,

 

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

 

Thanks,

 

Gerry

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors