Forum Discussion
Help with Complex Summarize Measure
Here is what I’m trying to accomplish: I have a table of employees, and a date table in my model. The employee table has a terminated date column. In my report, I have a date slicer. I would like t...
Use sumx function to sum your existing measure you calculated for days
Total Terminated Days = SUMX(Table1, [your measure])
Sample employee table
| employeeID | term_date |
| 1 | 1/27/2018 |
| 2 | |
| 3 | |
| 4 | 2/5/2018 |
| 5 | |
| 6 | |
| 7 | 4/15/2018 |
| 8 | |
| 9 | |
| 10 | |
| 11 | 5/1/2018 |
| 12 |
Use sumx function to sum your existing measure you calculated for days
Total Terminated Days = SUMX(Table1, [your measure])
Brilliant! I think SUMX and I will become friends. Thank you :)