Explore Courses Blog Tutorials Interview Questions
0 votes
in BI by (11.1k points)

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

enter image description here

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

enter image description here

1 Answer

0 votes
by (22.5k points)

Use the following measures

MinThreshold = MIN('Ranges'[Min])

MaxThreshold = MAX('Ranges'[Max])

Total Premium per ControlNo in Range =
VAR selectedControlNo =
    SELECTEDVALUE ( 'fact_Premium'[ControlNo] )
    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  

Browse Categories