Forum Discussion

tdailey77's avatar
tdailey77
Frequent Visitor
6 years ago
Solved

DAX comparison - VALUE OR FORMAT

Hello, I have my data source connected to Microsoft D365 Online, I used to use On-Prem that was connected to a SQL server. I am finding this change to be a huge pain in the %$@!   In my old report...
data protection
  • amitchandak's avatar
    amitchandak
    6 years ago

    tdailey77 , is po_opportunitydisposition is text column or whole number. Seem like the whole number. If so remove double quotes

     

    example

    Opportunities[po_opportunitydisposition]=936710003

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

tdailey77 , is po_opportunitydisposition is text column or whole number. Seem like the whole number. If so remove double quotes

 

example

Opportunities[po_opportunitydisposition]=936710003

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    6 years ago

    tdailey77 as amitchandak suggested, if it is a number, don't add quotes but also I would recommend to use IN statement for easy readability

     

    Total Show =
COUNTROWS(filter(Opportunities,Opportunities[po_opportunitydisposition] IN {
"936710003" ,
"936710002",
"936710005",
"936710004" ,
"936710008",
"936710010",
"936710007",
"936710009" }
)
)+0

or

Total Show =
COUNTROWS(filter(Opportunities,Opportunities[po_opportunitydisposition] IN {
936710003,
936710002,
936710005,
936710004,
936710008,
936710010,
936710007,
936710009 }
)
)+0

     

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

    • tdailey77's avatar
      tdailey77
      Frequent Visitor
      6 years ago

      Thank you for the suggestion! 

  • tdailey77's avatar
    tdailey77
    Frequent Visitor
    6 years ago

    Thank you, this solved it!! Very much appreciate the quick response too! I've been stuck on this for weeks, I guess I know where to go for help now. 🙂

     

    Tim