Power BI Filter Function Error

[CSPedrao]

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

     )

[Thejeswar · Accepted solution]

@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 · Accepted solution]

@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 · Accepted solution]

@Thejeswar 
It worked!!

Thanks very much for your help.

CSPedrao

[Thejeswar]

@CSPedrao ,

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

[CSPedrao]

Sorry, I've marked your your reply as solution now.

Thanks again!

CSPedrao

[Idrissshatila]

@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]

@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]

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