Forum Discussion
Solved
Power BI Filter Function Error
Hi, I was wondering if anyone can help me?! I created a measure and would like to use the filter function to exclude future month's, however I get a 'Operator or expression '()' not supported in th...
CSPedrao ,
You need to modify the logic as given below
Failed_SLA = calculate(DISTINCTCOUNT(Job[Id]),Filter (JOB, MONTH(Job[Date]) <= MONTH(today()) && Job[Failed]=1)) / Calculate(DISTINCTCOUNT(Job[Number]),Filter (JOB, MONTH(Job[Date]) <= MONTH(today()) && Job[Status]=4))+Calculate(DISTINCTCOUNT(Job[Number]),Filter (JOB, MONTH(Job[Date]) <= MONTH(today()) && Job[Status]=5))Regards,
