MEASURE NETWORDAYS WORKS DIFFERENTLY

Question

I use two measures that a priori should be the same, only that one uses on weekdays. When I use the function with DATEDIFF it works well and respects the dimcalendar filter, which is in star format. The problem comes when using NETWORKDAYS, it breaks the filter and returns a value of 2023. I know that the function to calculate one of the two dates has an ALL but it is a previous step to the calculation of the difference in dates... Because one inhibits him and the other does not?

anonymous · Accepted Answer

Hi&nbsp;Anonymous&nbsp;,
&nbsp;
This is because you filter from the slicer.
First of all, I reproduced your&nbsp;scenario.

If you return MAXDAY, you will find out that threre's blank returned in date 1/1/2023.

So, when you select 2024 in the slicer, it will return the result as follows:

To fix this, you can add a if condtition.
Since my slicer is created by&nbsp;the year of the date hierarchy, I used&nbsp;SELECTEDVALUE('Table'[Date].[Year]) to locate the year from the slicer.&nbsp;If your slicer's year field is from a column, not a hierarchy, just use SELECTEDVALUE('TABLENAME'[YEAR]).

Here's the modified measure:
NETWORKDAYS = VAR MAXDAY=MAX('Table'[Date])
VAR FECHA=MAXX(ALL('Table'),[Date])
VAR difflaborables=NETWORKDAYS(MAXDAY,FECHA)
RETURN IF(SELECTEDVALUE('Table'[Date].[Year])=YEAR(MAXDAY),difflaborables)

&nbsp;
Best Regards,
Stephen Tao
&nbsp;
If this post&nbsp;helps, then please consider&nbsp;Accept it as the solution&nbsp;to help the other members find it more quickly.
&nbsp;
&nbsp;