Forum Discussion
Anonymous
3 years agoNot applicable
power bi slicer visual
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
| SubBlock | Value | RunningTotal |
| 1 A | NULL | 3.164835165 |
| 1 A | NULL | 3.164835165 |
| 1 A | 3.164835165 | 3.164835165 |
| 1 B | 1.73 | 7.695610335 |
| 1 B | NULL | 7.695610335 |
| 1 B | 2.80077517 | 7.695610335 |
| 1 C | NULL | 12.56561033 |
| 1 C | 2.77 | 12.56561033 |
| 1 C | NULL | 12.56561033 |
| 1 C | 2.1 | 12.56561033 |
| 1 D | 6.401367521 | 25.00518486 |
| 1 D | NULL | 25.00518486 |
| 1 D | 4.561269841 | 25.00518486 |
| 1 D | 1.476937162 | 25.00518486 |
| 1 D | NULL | 25.00518486 |
| 1 D | NULL | 25.00518486 |
| 1 D | NULL | 25.00518486 |
| 1 E | 8.72011475 | 38.69990424 |
| 1 E | 2.364604633 | 38.69990424 |
| 1 E | NULL | 38.69990424 |
No Replies