Forum Discussion
Variable Measures?
Can you add a screen shot of your model relationships?
Not sure how DimDate/MonthSelect and your fact table relate.
sure no problem, hope this helps.
Hi,
hopefully I'm not confusing the issue further but as you are referring to and passing the dates for selected month do you need the relationship between selectedmonth and dimdate.
if its used for other purposes would it work by passing the ALL('DimDate') into the filter of your measure to avoid the filtering when selected.
NETWORK DAYS 2017_variable = CALCULATE(COUNTROWS('DimDate'),ALL('DimDate'), FILTER('DimDate', 'DimDate'[Day of Week Number] < 6),DATESBETWEEN(DimDate[Date],DATE(2017,[MonthNumSelect],1), DATE(2017,[MonthNumSelect],[EndofMonthday])))
Thanks for the reply, if I am understanding your first question; I I have the relationship between selectmonth and dimdate because the rest of the report uses dimdate and the graphs and slicers I would be using to filter this are all using dimdate; that being said I have tested and the relationship workd and the results are identical whether is filtered via dimdate or select month
I inserted the formula you gave and it didnt make the problem go away. Is there something else I should change first?
hmmm that would suggest that the filter may not be responsible
if you add the networkdays measure into a card on the report page are the day numbers changing as you expect them too.
