cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Bpark1994
Helper I
Helper I

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 the task is task 3 or 4 then I need the count of those together in the calculated column. The one I wrote doesn't add them together. Here is an example table and my desired result. Thanks!

 

NameTask
John1
John1
John2
Jim1
Jim2
Jane1
Jane2
Mike3
Mike4
Evan3
Evan4

 

 

desired result

TaskCalculated column count
14
23
34
44
3 REPLIES 3
amitchandak
Super User IV
Super User IV

@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]))


Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

amitchandak
Super User IV
Super User IV

@Bpark1994 , 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])

 

refer: https://www.youtube.com/watch?v=czNHt7UXIe8



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Sorry 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!

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Get Ready for Power BI Dev Camp

Power BI Dev Camp - June 24th

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors