Forum Discussion
Power BI - multiple filtering
- Anonymous1 year ago
Hi melikekurrt ,
Please try this way:
Here is my sample data:Use Numeric range parameter to create another table for slicer:
The minimum and maximum values here correspond to the minimum and maximum values of fxPeriod in your original data, respectively.
Then use this DAX to create a measure:
Filter = VAR _fxPeriod = SELECTEDVALUE(fxPeriod[Parameter]) RETURN IF( ISFILTERED(fxPeriod[Parameter]), IF( MAX('Table'[fxClosedPeriod]) = _fxPeriod || MAX('Table'[fxOpenPeriod]) = _fxPeriod, 1, 0 ), 1 )Set up the filter as shown below:
Output:
Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi melikekurrt ,
Please try this way:
Here is my sample data:
Use Numeric range parameter to create another table for slicer:
The minimum and maximum values here correspond to the minimum and maximum values of fxPeriod in your original data, respectively.
Then use this DAX to create a measure:
Filter =
VAR _fxPeriod = SELECTEDVALUE(fxPeriod[Parameter])
RETURN
IF(
ISFILTERED(fxPeriod[Parameter]),
IF(
MAX('Table'[fxClosedPeriod]) = _fxPeriod || MAX('Table'[fxOpenPeriod]) = _fxPeriod,
1,
0
),
1
)
Set up the filter as shown below:
Output:
Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.