Forum Discussion

asc's avatar
asc
Frequent Visitor
7 years ago
Solved

what if parameter using user created measure

I have sales data with material, actual_sale, target_sale along with many columns.

I have created measure %achieved_sale which is calculated as actual_sale/target_sale.

%achieved_sale has values from 0 - 500. which means if actual = target , achieved sale=100

 

now i want slicer on %achieved_sale

so i could see material wise actual_sale, target_sale and its related columns when i select %achieved_sale slicer range

eg. if i select %achieved_sale 0 to 50, I want all details of materials whose %achieved_sale is in between 0 - 50

also i want slicer values between min(%achieved_sale) to max(%achieved_sale)

 

is it possible to achieve this with what-if parameter?

2 Replies