Ignore page level filter an apply separate filter through DAX

[WTAS80486]

Hi,

I understand how to ignore page level filter for one visual through DAX

But how to apply different filter than the page level filter in another measure used for the same visual

Page level filter is status Can, Close, Open

Measure 1-This counts all Orders irrespective of order status and type

Total Order Created = CALCULATE(DISTINCTCOUNT(order[ORDERID]),ALL( order[Order Status],order[ type]))

Now I want to create another measure (Total Orders Completed) to count order ids with status as complete or close

Thanks

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure how your datamodel looks like, but please try something like below.

order status complete or close =
CALCULATE (
    DISTINCTCOUNT ( order[ORDERID] ),
    FILTER (
        ALL ( order[Order Status] ),
        order[Order Status] IN { "Close", "Complete" }
    ),
    ALL ( order[type] )
)

[WTAS80486]

@Jihwan_Kim Thank you!