Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

power bi slicer visual

Spoiler
Spoiler
 

Hi,

1)I have table1 with fields subblock , value, runningTotal.

2)created single input value slicer InputMW.

 

Expected Result:

If a user enters a value in inputMW slicer.get the rows from table1  where runningTotal is next available value greater than equal(>=) to  input value.

ex:if input value is 10 get all rows upto 1C(12.56561033)

ex: if input value is  20 get all rows upto 1D( 25.00518486).

craeted min value measure:

MeasureMin = MINX(FILTER('Table1','Table1'[RunningTotal] >= InputMW[InputMW Value]), 'Table1'[RunningTotal])

data and pbix file attached.

Please help

 

SubBlockValueRunningTotal
1 ANULL3.164835165
1 ANULL3.164835165
1 A3.1648351653.164835165
1 B1.737.695610335
1 BNULL7.695610335
1 B2.800775177.695610335
1 CNULL12.56561033
1 C2.7712.56561033
1 CNULL12.56561033
1 C2.112.56561033
1 D6.40136752125.00518486
1 DNULL25.00518486
1 D4.56126984125.00518486
1 D1.47693716225.00518486
1 DNULL25.00518486
1 DNULL25.00518486
1 DNULL25.00518486
1 E8.7201147538.69990424
1 E2.36460463338.69990424
1 ENULL38.69990424

 

 

 

 

No Replies