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 this context' error, the measure works without the filter function but not with it, any ideas why?

 

Thanks in advance

CSP

 

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()))

     )

 

 

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,

7 Replies

  • Thejeswar's avatar
    Thejeswar
    Super User
    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,

      • Thejeswar's avatar
        Thejeswar
        Super User
        2 years ago

        CSPedrao ,

        Welcome. Kindly mark my reply as a solution! Looks like you have marked your reply as a solution.

  • Idrissshatila's avatar
    Idrissshatila
    Super User
    2 years ago

    CSPedrao ,

     

    try it like this 

     

    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 💡

    • 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 💡