I would like to calculate the Standard Deviation but without including 2 days (Saturdays and Sundays), but the result is the same with or without the filter. I calculate it on excel and it should be larger than in Power BI
This is the formula i am using:
StandardDeviation = CALCULATE(STDEV.S(‘General Tickets'[Request Date]), FILTER(‘General Tickets’, ‘General Tickets'[Day Number] <> 6 || 7))
But i am not sure why it doesn’t apply my filters.