Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
WTAS80486
Helper IV
Helper IV

Ignore page level filter an apply separate filter through DAX

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

1 ACCEPTED SOLUTION
Jihwan_Kim
Super User
Super User

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] )
)

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.


Click here to visit my LinkedIn page

Click here to schedule a short Teams meeting to discuss your question.

View solution in original post

2 REPLIES 2
Jihwan_Kim
Super User
Super User

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] )
)

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.


Click here to visit my LinkedIn page

Click here to schedule a short Teams meeting to discuss your question.

@Jihwan_Kim Thank you!

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.