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