Is it possible to create numeric range slicer and filter data in matrix in Power BI Desktop?

Question

I am having a matrix with two measures Total Premium and Binds Total

I want to create a slider that would filter matrix based on amount

Answer 1

Use the following measures

MinThreshold = MIN('Ranges'[Min])

MaxThreshold = MAX('Ranges'[Max])

Total Premium per ControlNo in Range =
VAR selectedControlNo =
    SELECTEDVALUE ( 'fact_Premium'[ControlNo] )
RETURN
    IF (
        CALCULATE ( [Total Premium], 'fact_Premium'[ControlNo] = selectedControlNo )
            >= [MinThreshold]
            && CALCULATE ( [Total Premium], 'fact_Premium'[ControlNo] = selectedControlNo )
                < [MaxThreshold],
        [Total Premium],
        BLANK ()
    )

Learn more about Power BI by enrolling in the Power BI Certification course