Forum Discussion
Variable Measures?
MIN(MonthSelect[MonthNumber]) is pretty much functionally identical to the one I have ... as when the filter is on it will display only the month filtered.
However still causes the same problem in my 'WFP YTD ration" being off (except the new number is slightly different as it reflects januarys network days)
I made the calculated columns but cannot put them into the measure as it doesnt refer to a min max etc
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?
