Combining a IF AND function

[YoussefN]

Hi,

I have two calculated columns. Now I want to combine the formula so that I have 1 calculated column but I am keep getting a syntax error.

Is_FTR = IF(AND(CALCULATE(DISTINCTCOUNT(PBI_SER_Work_order[No]);FILTER(PBI_SER_Work_order;PBI_SER_Work_order[callno] = PBI_SER_ServiceCall[No])) = 1; PBI_SER_ServiceCall[Date Time Status 70] <> BLANK()); TRUE(); FALSE())

Number of Orders = CALCULATE(DISTINCTCOUNT(PBI_SER_Serviceorder[No]);FILTER(PBI_SER_Serviceorder;PBI_SER_Serviceorder[call_no] = PBI_SER_ServiceCall[No]))

I tried the following, but as I said I am getting a syntaxx error.

COMBINED = IF(AND(CALCULATE(DISTINCTCOUNT(PBI_SER_Work_order[No]);FILTER(PBI_SER_Work_order;PBI_SER_Work_order[callno] = PBI_SER_ServiceCall[No])) = 1; (DISTINCTCOUNT(PBI_SER_Serviceorder[No]);FILTER(PBI_SER_Serviceorder;PBI_SER_Serviceorder[call_no] = PBI_SER_ServiceCall[No]))

 = 1;PBI_SER_ServiceCall[Date Time Status 70] <> BLANK()); TRUE(); FALSE())

[Greg_Deckler]

Which calculation are you getting a syntax error on? What is the syntax error? Can you post sample/example data that would make this easier to recreate?

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490