Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

DAX Error

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-...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    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

    result.JPG
Anonymous's avatar
Anonymous
Not applicable
6 years ago

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's avatar
Anonymous
Not applicable
6 years ago

Hi Anonymous    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