IF Formula

[Anonymous]

Dear all,

I'm trying to get "Einzel" if the Document No is smaller than 300000 and "Vertrag" if the Document No is bigger than 300'000.
For the moment I only get "Einzel". My goal at the end is to use this measure als filter.
Thanks in advance for your inpouts:

• Einzel = IF(DISTINCTCOUNT('Service Order'[Document No])<300000, "Einzel", "Vertrag")
  
  
  

[Anonymous]

Thank you @PaulDBrown worked like a charm.

[PaulDBrown · Accepted solution]

Try:

Einzel =
IF ( SELECTEDVALUE ( 'Service Order'[Document No] ) < 300000, "Einzel", "Vertrag" )