Forum Discussion

Bpark1994's avatar
Bpark1994
Icon for Helper I rankHelper I
5 years ago

Need Dax Help Please!

Hi guys   I have 2 tables. They are related through the Task column   i need to write a calculated column that gives me a count of each task. Seems simple but the part that's tripping me up is if...
DAX
Power
POWER BI Dax rules
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Bpark1994 , Try a measure like

Measure 2 = if( max('Table'[Task]) in {3,4} ,CALCULATE(COUNT('Table'[Name]), 'Table'[Task] in {3,4}), COUNT('Table'[Name]))