Forum Discussion

CSPedrao's avatar
CSPedrao
Regular Visitor
2 years ago
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...
Need Help
  • Thejeswar's avatar
    Thejeswar
    2 years ago

    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,

  • CSPedrao's avatar
    CSPedrao
    2 years ago

    Thejeswar 
    It worked!!

    Thanks very much for your help.

    CSPedrao

     

CSPedrao's avatar
CSPedrao
Regular Visitor
2 years ago

Idrissshatila 

Hi,

It made no difference, still gives me the same message 'Operator or expression '()' is not supported in this context'.

 

Thanks anyway!

CSPedrao

Idrissshatila's avatar
Idrissshatila
Super User
2 years ago

CSPedrao ,

 

try it now

 

Failed_SLA = 

    calculate(DISTINCTCOUNT(Job[Id]),Job[Failed]=1)

        /

     Calculate(DISTINCTCOUNT(Job[Number]),Job[Status]=4)+Calculate(DISTINCTCOUNT(Job[Number]),Job[Status]=5),

     Filter (JOB, MONTH(Job[Date].[Month]) <= MONTH(today())

 

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote for my Community Mobile App Idea 💡