Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Name | Task |
John | 1 |
John | 1 |
John | 2 |
Jim | 1 |
Jim | 2 |
Jane | 1 |
Jane | 2 |
Mike | 3 |
Mike | 4 |
Evan | 3 |
Evan | 4 |
desired result
Task | Calculated column count |
1 | 4 |
2 | 3 |
3 | 4 |
4 | 4 |
@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]))
@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
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
42 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
39 | |
33 | |
18 | |
17 |