Need to show different Measure values based filter selections

[balakrishna171]

Hi Team,

I have 3 Measures in my Model 

 1. NSAT Measure Value
 2. WW NSAT Measure Value
 3. Final Measure

                      I am fine with 1st and 2nd Measure calculations but the calculation for 3rd measure is, based on filter selections it has to display Measure 1 or 2. Details given in below screen shot.

Thank you in advance.

Bala Krishna

[v-juanli-msft · Accepted solution]

Hi @balakrishna171 

we need to use "isfiltered"(or other functions) to identify if a filter is applied.

https://community.powerbi.com/t5/Desktop/Show-result-in-table-only-if-it-is-filtered/td-p/586917

for filters in any table, we need to use "isfiltered" for each slicer(column) per table.

in my example, filter1 show filters in "geo table", filter2 show filters in "sample data",filter1 show filters in "weight table".

Measure =
VAR filter1 =
    ISFILTERED ( 'geo table'[country name] )
VAR filter2 =
    ISFILTERED ( 'sample data'[person id] )
VAR filter3 =
    ISFILTERED ( 'weight table'[region] )
RETURN
    IF (
        ISFILTERED ( 'sample data'[question desc] ),
        37,
        IF (
            filter1 || filter2
                || filter3,
            39,
            IF ( NOT ( filter1 && filter2 && filter3 ), 37 )
        )
    )

result1, 3

result 2

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[balakrishna171]

Hi Maggie,

Superb and great solution. it worked for me well.

Thanks again.

Regards,

Bala

[balakrishna171]

Hi Team,

Any help on this would be appreciable.