Help on formula (Filter)

[Anonymous]

Hello Team,

Hope you are fine.

I am having an issue to add a filter on the below formula:

ND_calc = IF (

ISFILTERED ( Sales_main[Description2] ),

COUNTROWS (

FILTER (

VALUES ( Sales_main[Sell_to_Customer_No] ),

CALCULATE ( SUM ( Sales_main[BundleSalesQuantity] ) ) > 0

)

)

)

I need to add a filter so that it take only the Customer number which are not 99997,99998,99999 from the table Sales_main[Customer_No]

Thank you for your help.

Kind Regards.

[Jihwan_Kim · Accepted solution]

Hi,

I assume the customer number is Number-formatted

Please try the below whether it suits your requirement.

ND_calc NEW =
IF (
    ISFILTERED ( Sales_main[Description2] ),
    COUNTROWS (
        FILTER (
            VALUES ( Sales_main[Sell_to_Customer_No] ),
            NOT ( Sales_main[Sell_to_Customer_No] IN { 99997, 99998, 99999 } )
                && CALCULATE ( SUM ( Sales_main[BundleSalesQuantity] ) ) > 0
        )
    )
)