Need help in calculating Percentage slider based on column value

[mandeeps19]

Hi All,

I have a requirement to create a percentage filter for the duration column which is in days. The idea is to create a filter to reduce to effect of holiday's etc on the specific data.

sample data - 

Request ID	Status	Duration
X1	ABC1	1.6
X2	ABC2	1.2
X3	ABC3	4
X4	ABC4	10
X5	ABC5	2
X6	ABC6	4.8
X7	ABC7	23
X8	ABC8	2
X9	ABC9	1
X10	ABC10	0.4
X11	ABC11	3
X12	ABC12	6.9
X13	ABC13	71
X14	ABC14	1

I want to calculate a overall percentage based on the overall duration. and that measure will be shown as slider and if we want to reduce overall 10 % of the duration then it should effect the overall data.

[amitchandak · Accepted solution]

@mandeeps19 , I think you need to use the what if parameter

a measure like

sumx(Table, [Duration] *(100+[what if measure])/100 )

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