Forum Discussion
Bpark1994
Helper I
Helper INeed 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...
amitchandak
Super User
Super UserBpark1994 , I think one table is missing. This how you can get new column in table 2 from tbale
Countx(filter(Table1, Table2[Task] =Table1[Task]),Table1[Name])
The above one can also done using measure with task
count(Table1[Name])
Bpark1994Helper I
Helper ISorry this is not the desired result I am looking for. I don't just want to count the tasks, I also need conditional logic that adds tasks 3 and 4 together as described above. I appreciate the help though!