DAX Error

[Anonymous]

Hi all,

Im getting error "The True/False expression does not specify a column. Each True/False expressions used as a table filter expression must refer to exactly one column."

I have tried Home---> Enter Data create a new table then Im using Calculated Column  

Column = SWITCH(FIRSTNONBLANK('Table'[Service Level Agreement],'Table'[Service Level Agreement]),

"Maintain Tax Certificates",CALCULATE([Within-SLA] / [ticketclosed month basis],FILTER('Finallist-left','Finallist-left'[RequestType]=="Account analysis" && "Marine Enquiery"),0),

"Incorrect Invoice tax",CALCULATE([Within-SLA] / [ticketclosed month basis],FILTER('Finallist-left','Finallist-left'[RequestType]=="Incorrect Invoice"),0))

can any one please help me?   how can i solve this   otherswise how to add static text?   thanks in advance

[harshnathani]

HI @Anonymous ,

Try something like this

Column =
SWITCH (
    FIRSTNONBLANK (
        'Table'[Service Level Agreement],
        'Table'[Service Level Agreement]
    ),
    "Maintain Tax Certificates", CALCULATE (
        [Within-SLA] / [ticketclosed month basis],
        FILTER (
            'Finallist-left',
            'Finallist-left'[RequestType] = "Account analysis"
                && 'Finallist-left'[RequestType] = "Marine Enquiery"
        )
    ),
    "Incorrect Invoice tax", CALCULATE (
        [Within-SLA] / [ticketclosed month basis],
        FILTER (
            'Finallist-left',
            'Finallist-left'[RequestType] = "Incorrect Invoice"
        )
    )
)

Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

[Anonymous]

Hi @harshnathani    it's working fine ,  i need current Month,  Last Month  data based on that measure  could you please help me, thansk in Advance

Regards,

Rajesh

[fhill]

Thinking along the same lines as @parry2k 

I don't have your full table structure, but I hope this simplier example helps:

[parry2k]

@Anonymous not sure what you are trying to achieve but this code ,0 , not sure why it is there.

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[Anonymous · Accepted solution]

Hello @parry2k I used Get data then I have entered 2 faithful these are static columns, then I tried Caluclate

Column: CALCULATE([Inside-SLA]/[ticket closed month base]), I need a result like this