- Write DAX Formula to count number of Users with certain events

[amitchandak]

@91asma2 , Try to create measures like

for open

calculate(count(Table[Event_id]), filter(Table, Table[Event_type]="open registration"))

or
calculate(count(Table[Event_id]), filter(Table, Search("Open", Table[Event_type],,0) >0))

for close

calculate(count(Table[Event_id]), filter(Table, Table[Event_type]="Close registration"))

calculate(count(Table[Event_id]), filter(Table, Search("Close", Table[Event_type],,0) >0))

refer to my Beginer series: https://www.youtube.com/watch?v=wvsAzTqSDVg&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb