Help with dax to create new measure

[kelcicoe]

I am new to PowerBI and needing to create a new measure.  I am trying to learn DAX but its going slowly.

I am trying to create a new variable that calculates the # of encounters with abx order (Enc With ABX Order) by the total encounters (Total Enc)  BUT I need it limited to a single antibiotic (Med Root = azithromycin).  Right now it is limited to all antimicrobials.  Is there a way to do this?  

[kelcicoe]

Yes it is currently -  I am needing to limit it essential to Enc with azithromycin order

[kelcicoe]

But it is for all antimicrobials.  I am wanting to limit calculation to a single antimicrobial

[ray_aramburo · Accepted solution]

Then write something like ABX_order_count = CALCULATE(COUNT(TableName[Enc With ABX Order]), TableName[MedRoot] = "azithromycin")

You need to write the text string the same as your values so ensure that column is standardized.

[kelcicoe]

Thank you so much!

[kelcicoe]

Yes

[ray_aramburo]

Is the  # of encounters with abx order (Enc With ABX Order) an existing column from your table?