https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Countrows-regardless-of-date-filter-and-relationship/m-p/1187199#M18695 <P>The following measure counts the orders regardless the date relationship:</P><DIV><DIV><SPAN>COUNTX(FILTER(ALL(),tblOrder[Status]=16),tblOrder[Order Number])</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>But it also disables the item master relationship.</SPAN></DIV><DIV><SPAN>How can I solve that?</SPAN></DIV></DIV> Sun, 28 Jun 2020 12:05:02 GMT joshua1990 2020-06-28T12:05:02Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Countrows-regardless-of-date-filter-and-relationship/m-p/1186570#M18665 <P>Hello everyone!</P><P>I have 3 tables that are linked with a date key or an item key.</P><P>The structure is like:</P><P>ItemMaster</P><TABLE border="1"><TBODY><TR><TD>Item (key)</TD><TD>Description</TD><TD>Value</TD></TR><TR><TD>1</TD><TD>Keys</TD><TD>5</TD></TR><TR><TD>2</TD><TD>Tube</TD><TD>10</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>tblOrderState</P><TABLE border="1"><TBODY><TR><TD>Item (key)</TD><TD>Order</TD><TD>State</TD><TD>Date (key)</TD></TR><TR><TD>1</TD><TD>A2</TD><TD>50</TD><TD>01.01.2020</TD></TR><TR><TD>1</TD><TD>A3</TD><TD>95</TD><TD>01.02.2020</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>the tblOrderState is linked with the calendar table.</P><P>On the page is a filter for the whole page for the current week.</P><P>Now I need to determine the number of orders that have the "50" regardless of the date.</P><P>How would you do that?</P> Sat, 27 Jun 2020 14:18:31 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Countrows-regardless-of-date-filter-and-relationship/m-p/1186570#M18665 joshua1990 2020-06-27T14:18:31Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Countrows-regardless-of-date-filter-and-relationship/m-p/1186601#M18666 <P>Can you show how you are slicing your data? you could try</P><LI-CODE lang="markup">Measure = CALCULATE ( COUNTROWS ( tblOrderState ), FILTER ( ALL ( tblOrderState[OrderState] ), tblOrderState[OrderState] = 50 ) )</LI-CODE><P>&nbsp;</P> Sat, 27 Jun 2020 15:00:53 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Countrows-regardless-of-date-filter-and-relationship/m-p/1186601#M18666 AntrikshSharma 2020-06-27T15:00:53Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Countrows-regardless-of-date-filter-and-relationship/m-p/1187085#M18690 <P>Thanks for your reply!</P><P>It is not working since I am using a filter for the week on the whole page.</P><P>Filter on this page: week</P><P>&nbsp;</P><P>How can I cut the active date relationship?&nbsp;</P> Sun, 28 Jun 2020 08:25:05 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Countrows-regardless-of-date-filter-and-relationship/m-p/1187085#M18690 joshua1990 2020-06-28T08:25:05Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Countrows-regardless-of-date-filter-and-relationship/m-p/1187199#M18695 <P>The following measure counts the orders regardless the date relationship:</P><DIV><DIV><SPAN>COUNTX(FILTER(ALL(),tblOrder[Status]=16),tblOrder[Order Number])</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>But it also disables the item master relationship.</SPAN></DIV><DIV><SPAN>How can I solve that?</SPAN></DIV></DIV> Sun, 28 Jun 2020 12:05:02 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Countrows-regardless-of-date-filter-and-relationship/m-p/1187199#M18695 joshua1990 2020-06-28T12:05:02Z