Forum Discussion

ff6d's avatar
ff6d
Icon for Helper I rankHelper I
8 years ago

Using Conditions when filtering

Hi,    I want to filter on shops in my data set if they ONLY used supplier A and B and not C. E.g. if the shop used supplier A for 50 euros, B for 20 euros and C for 1 euros this shop should be exc...
Need Help
ff6d's avatar
ff6d
Icon for Helper I rankHelper I
8 years ago

Hi Yuliana,

 

When I use your measure my data filters on those who only use supplier C. Can you figure out how I can "reverse" the measure?

 

Thanks! 

 

Regards,

v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi ff6d,

 

As you can see the result is correct in my test. Please make sure you wrote the correct DAX formula for above measure. Besides, check whether you set the right value for "Visual level filter", it should be "Is not blank".

flag1 =
IF (
    CALCULATE (
        COUNT ( Sheet1[Supplier] ),
        FILTER ( ALLEXCEPT ( Sheet1, Sheet1[Shops] ), Sheet1[Supplier] = "C" )
    )
        > 0,
    BLANK (),
    1
)

To help you "reverse" the measure, please share sample data and the actual measure formula you used which can better describe your scenario.

 

Regards,

Yuliana Gu