Forum Discussion
Convert Tableau calculations to Power BI
How to convert this tableau fnction into Power BI Dax ?
COUNTD(if UPPER([ TYPE 1 ])='MAJOR' THEN [NAMES]END)
2 Replies
- amitchandak
Super User
Anonymous , Try like
countx(filter(Table, UPPER(Table[TYPE 1]) ="MAJOR"), Table[NAMES])
or
countx(Table, if(UPPER(Table[TYPE 1]) ="MAJOR" , Table[NAMES], blank()))
