Forum Discussion
Solved
Countblank & Max
Hi
The senerio is I have a table of repair jobs by agent, job age and comments. I want to know the Oldest (Max) Job age for any jobs with BLANK comments. I will be slicing the results by agent.
I would expect this result from the table below.
Results
| Agent | MAX Job Age , Commens BLANK |
| Jon | 18 |
| Jim | 47 |
Jobs table
| Ref | Agent | Job Age | Comments |
| 113 | Jon | 4 | sfodagodsjl |
| 551 | Jon | 18 | |
| 189 | Jon | 22 | dsgjsoigri |
| 525 | Jon | 5 | ghl;jfsoifjl |
| 445 | Jon | 12 | lksgjlskfjlkf |
| 407 | Jon | 14 | |
| 213 | Jim | 43 | |
| 515 | Jim | 35 | sdgsfjgsj |
| 146 | Jim | 47 | |
| 216 | Jim | 35 | |
| 170 | Jim | 7 | |
| 296 | Jim | 18 | sgsifjosfjhl |
What DAX would you suggest I use to acheive this.
RIchard
cottrera , Try a measure like
maxx(filter(Table, isblank(Table[Comments])),[Job])
2 Replies
cottrera , Try a measure like
maxx(filter(Table, isblank(Table[Comments])),[Job])
Works fine many thanks
