Countrows regardless of date filter and relationship

[joshua1990]

Hello everyone!

I have 3 tables that are linked with a date key or an item key.

The structure is like:

ItemMaster

Item (key)	Description	Value
1	Keys	5
2	Tube	10

tblOrderState

Item (key)	Order	State	Date (key)
1	A2	50	01.01.2020
1	A3	95	01.02.2020

the tblOrderState is linked with the calendar table.

On the page is a filter for the whole page for the current week.

Now I need to determine the number of orders that have the "50" regardless of the date.

How would you do that?

[AntrikshSharma]

Can you show how you are slicing your data? you could try

Measure =
CALCULATE (
    COUNTROWS ( tblOrderState ),
    FILTER ( ALL ( tblOrderState[OrderState] ), tblOrderState[OrderState] = 50 )
)

[joshua1990]

Thanks for your reply!

It is not working since I am using a filter for the week on the whole page.

Filter on this page: week

How can I cut the active date relationship? 

[joshua1990]

The following measure counts the orders regardless the date relationship:

COUNTX(FILTER(ALL(),tblOrder[Status]=16),tblOrder[Order Number])

But it also disables the item master relationship.

How can I solve that?