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

5 Replies

  • parry2k's avatar
    parry2k
    Super User
    6 years ago

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

     

    Thinking along the same lines as parry2k 

     

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

     

     

  • 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