Forum Discussion

kukszi's avatar
kukszi
Helper I
3 years ago

Using measure as a slicer

Hi there,   I'd like to create a measure for price ranges that I can use as a filter criteria in a slicer or to show the price distribution in a chart. The approach I try to do is the following: ...
Need Help
TaylorPBI21's avatar
TaylorPBI21
Resolver I
3 years ago

Hi kukszi ,

 

You could just delete your price range table and use this new calculated column instead...😎

 

Price Tiers = 
Switch(
TRUE(),
'Table'[Average Price] > 0 && 'Table'[Average Price] <= 15, "$0-$15",
'Table'[Average Price] > 15 && 'Table'[Average Price] <= 20, "$15-$20",
'Table'[Average Price] > 20 && 'Table'[Average Price] <= 25, "$20-$25",
'Table'[Average Price] > 25 && 'Table'[Average Price] <= 30, "$25-$30",
'Table'[Average Price] > 30 && 'Table'[Average Price] <= 35, "$30-$35",
'Table'[Average Price] > 35, "$35"
)

 

Many Thanks,

 

Taylor 😎