Dynamic Grouping

[Anonymous]

Hi! 

I have a column with the probability of booking cancellation.  I want to create a slicer that allows the client to stablish a probability treshold that defines "Will cancel" and "Will not cancel" depending of the cancellation probability.

|---------O------------------------|                             Day              Reservation      Will Cancel           Will not cancel

0            0,3                                1                              01-04-19              30               5                                25

                                                                                   02-04-19             25                10                             15

So from 0 to 0,3 -> Will not cancel

0.3 to 1 -> Will cancel

The client can move the probability treshold and the categories Will/Will not Cancel must change

Thanks a lot!!

[v-lili6-msft]

hi, @Anonymous 

First, you should know that calculated column and calculate table can't be affected by any slicer. you could create a measure instead of column.
Notice:
1. Calculation column/table not support dynamic changed based on filter or slicer.
2. Measure can be affected by filter/slicer, so you can use it to get dynamic summary result.
here is reference:
https://community.powerbi.com/t5/Desktop/Different-between-calculated-column-and-measure-Using-SUM/t...
https://www.sqlbi.com/articles/calculated-columns-and-measures-in-dax/

Second, Use What if parameter in power bi to add a probability threshold and create a measure based on it.

https://docs.microsoft.com/en-us/power-bi/desktop-what-if

Best Regards,

Lin