Forum Discussion

balakrishna171's avatar
balakrishna171
Frequent Visitor
6 years ago
Solved

Need to show different Measure values based filter selections

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

Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    6 years ago

    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.

3 Replies

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    6 years ago

    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's avatar
      balakrishna171
      Frequent Visitor
      6 years ago

      Hi Maggie,

       

      Superb and great solution. it worked for me well.

      Thanks again.

       

      Regards,

      Bala