0 votes
1 view
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] )
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  

Welcome to Intellipaat Community. Get your technical queries answered by top developers !


Categories

...