Forum Discussion

TCavins's avatar
TCavins
Helper V
3 years ago

Measure Filter

I've combined 2 datasets into one for a map in Power BI. Lets call them People and Centers. I've added a column called IsPerson, setting it to either 1 or 0 based on the dataset.   Here's a sample ...
Need Help
TCavins's avatar
TCavins
Helper V
3 years ago

amitchandak I think I'm close. The following works if I have filtered either value 2 or 3 and filtered value 4 or value 5. Any other combinations don't seem to work.

I placed this measure on a visual level filter and set it = 1 but selected just "Blue" doesn't work. Selected "Blue" and "Car" doesn't work. "Blue" and "Group 1" works. "Blue", "Car", and "Group 1" works. Just "Group 1" doesn't work, etc.

MeasureFilter = 
//COUNTROWS(FILTER('Table 2', 'Table 2'[Value2] IN ALLSELECTED(val2s[Value2]) || 'Table 2'[Value3] IN ALLSELECTED(val3s[Value3]) || 'Table 2'[Value4] IN ALLSELECTED(val4s[Value4])|| 'Table 2'[Value5] IN ALLSELECTED(val5s[Value5])))

    IF(
        (
            (
                SELECTEDVALUE('Table 2'[Value2]) IN ALLSELECTED(val2s[Value2])  || NOT(ISFILTERED(val2s[Value2]))
            )
            &&
            ( 
                SELECTEDVALUE('Table 2'[Value3]) IN ALLSELECTED(val3s[Value3]) || NOT(ISFILTERED(val3s[Value3]))
            )
        )
        ||
        (
            ( 
                SELECTEDVALUE('Table 2'[Value4]) IN ALLSELECTED(val4s[Value4]) || NOT(ISFILTERED(val4s[Value4]))
            )
            &&
            ( 
                SELECTEDVALUE('Table 2'[Value5]) IN ALLSELECTED(val5s[Value5]) || NOT(ISFILTERED(val5s[Value5]))
            )
        ),
        1,
        0
    )

 

TCavins's avatar
TCavins
Helper V
3 years ago

Initial testing of the following seems to work:

MeasureFilter = 

    IF(
        
        (SELECTEDVALUE('Table 2'[Value1]) = 1 && OR(
                    NOT(ISFILTERED(val2s[Value2])) ,
                    SELECTEDVALUE('Table 2'[Value2]) IN ALLSELECTED(val2s[Value2])
                )
        &&
        SELECTEDVALUE('Table 2'[Value1]) = 1 && OR(
                    NOT(ISFILTERED(val3s[Value3])) ,
                    SELECTEDVALUE('Table 2'[Value3]) IN ALLSELECTED(val3s[Value3])
                )
        )
        ||
        (
        SELECTEDVALUE('Table 2'[Value1]) = 0 && OR(
                    NOT(ISFILTERED(val4s[Value4])) ,
                    SELECTEDVALUE('Table 2'[Value4]) IN ALLSELECTED(val4s[Value4])
                )
         &&
        SELECTEDVALUE('Table 2'[Value1]) = 0 && OR(
                    NOT(ISFILTERED(val5s[Value5])) ,
                    SELECTEDVALUE('Table 2'[Value5]) IN ALLSELECTED(val5s[Value5])
                )
        )
        ,
        1,
        0
    )
  • TCavins's avatar
    TCavins
    Helper V
    3 years ago

    amitchandak 

    When I apply this measure as a filter to a ESRI map that has a large amount of points, I do not get the as many records as I should. I am only seeing a handful of points where I should see a few hundred. Using the same data and same filter with a table displaying the data, I get the number of rows that I expect.


    Any thoughts?