2 String Columns(A & B), Need to Count Result in B based on A

[Anonymous]

Hi,

I'm very new to DAX in general and come from a C# background (Nothing Alike  )

I have a table with the following Columns:

ID - Int

DateTimeCreated - DateTime

EventSource - Varchar

EventType - Varchar

Description - Varchar

ClosingTime - Time

Status - Varchar

The data would typically look as follows:

I would like to have a count for how many times an EventSource is Locked/Unlocked. Example in data provided Box 20 Lock has a Locked count of 3

Your help is appreciated.

Thank you

[v-huizhn-msft · Accepted solution]

Hi @Anonymous,

Please try the following formula to create calculated columns.

Lock=CALCULATE(COUNTA(Table[status]),FILTER(ALLEXCEPT(Table,Table[EventSource]),Table[status]="locked"))

Unlock=CALCULATE(COUNTA(Table[status]),FILTER(ALLEXCEPT(Table,Table[EventSource]),Table[status]="unlocked"))

If you have other issues, don't hesitate to let me know.

Best Regards,
Angelia

[Anonymous]

Thanks a lot!