Need help writing a DAX to count distinct values with multiple filters

[Anonymous]

I have this table

I need to write a DAX that finds Admit Status of 'N' or 'E'

Then it need to modify FAYEAR to get the left two characters and change that to 202110

So it would be "20" & Left(FAYEAR,2) & "10"  newvalue

So then it would (Admit Status of 'N' or 'E') and "20" & Left(FAYEAR,2) & "10"  newvalue

I wrote this but I am doing something wrong.

THANK YOU!

H21 = CALCULATE(DISTINCTCOUNT('Main'[ID]), FILTER('Main',Main[ADMITSTATUS] = "N" || 'Main'[ADMITSTATUS] = "E" && Main[ADMITTERM] = "20" & LEFT(CALCULATE(DISTINCT(H2A_FR[FAYEAR])), 2)& "10"))

[Greg_Deckler]

@Anonymous Perhaps:

H21 = 
  COUNTROWS(
    DISTINCT(
      ADDCOLUMNS(
       FILTER('Main',Main[ADMITSTATUS] = "N" || 'Main'[ADMITSTATUS] = "E"),
        "ADMITTERM", "20" & LEFT(CALCULATE(DISTINCT(H2A_FR[FAYEAR])), 2)& "10"
      )
    )
  )

[Anonymous]

Error that it cannot add columns because already exists.

[v-kkf-msft · Accepted solution]

Hi @Anonymous ，

In the formula, "ADMITTERM" uses the same name as the Main[ADMITTERM] field, you need to replace it, such as "ADMITTERM 2".

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

[Anonymous]

Thank you!

[Anonymous]

I think I figured it out, 

H21 = CALCULATE(DISTINCTCOUNT('Main'[ID]), FILTER('Main',Main[ADMITSTATUS] in {"N","E"} && Main[ADMITTERM] = "20" & LEFT(CALCULATE(DISTINCT(H2A_FR[FAYEAR])), 2)& "10"))

But my question still remains what is I had to combine filters

(Filter A = "b" or Filter B = "b") and Filter C = "x"

How would you write the above filter in DAX?