Forum Discussion
Solved
Help
Hello all, Can anyone please help me to understand whats the mistake I'm making in the following DAX formula: Site Visits = COUNTROWS( SUMMARIZE('4. CoW Productivity', '4. CoW Productivity'...
Hi SantiagoTorres ,
Sorry for my late reply.
Try this
Site Visits = COUNTROWS(DISTINCT('4 CoW Productivity'))Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Stephen, thank you for your response,
Still not getting the values I need,
| Project Number | Project Address | Date Created | Assignee(S) |
| B037 B038 | 20 Miller Street | 25/8/21 | Steve Gray |
| B021 | 3 Market Street | 25/8/21 | Jake Van der Zant |
| B080 | 331 Orrong Road | 25/8/21 | Paul O'Callaghan |
| B080 | 331 Orrong Road | 25/8/21 | Paul O'Callaghan |
| B035 B036 | 12-18 Miller Street | 25/8/21 | Steve Gray |
| B021 | 3 Market Street | 25/8/21 | Jake Van der Zant |
| B010 | 10 Tennyson Street | 25/8/21 | Paul O'Callaghan |
| B010 | 10 Tennyson Street | 25/8/21 | Paul O'Callaghan |
| B035 B036 | 12-18 Miller Street | 25/8/21 | Steve Gray |
| B080 | 331 Orrong Road | 23/8/21 | Paul O'Callaghan |
I need to get project numbers by date (#visits), but when the project number is repeated on the same date, I should count it just once. For instance, in this table B080=2 and B010=1, etc.,
Many thanks,
Andres Torres
Hi SantiagoTorres ,
Sorry for my late reply.
Try this
Site Visits = COUNTROWS(DISTINCT('4 CoW Productivity'))
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.