Forum Discussion
Solved
group by row count
hi guys, i've got a question for you. i have two relative datasets, one is data related to projects with the client id as one of the keys, the other is another dataset with client id and client n...
Hi orihait
Not a straight forward one but this is possible.
you need to create a new table with the following DAX
number of projects = GENERATESERIES(1,100,1)this will generate a column with 1 to 100 in the cellsThen add a column withNumber of Clients = COUNTAX(FILTER(projects,projects[client ID]='number of projects'[Value]),projects[client ID] = 'number of projects'[Value])you will end up with a table with 2 columns, a list of how many clients could be attached to a project and how many time that happens. So:1 client attached = 2 projects2 clients attached = 2 projects3 clients attached = 0 projectsetcThen you can create your visual.If this solves your issue please mark this as the solution :)
Hi orihait
Not a straight forward one but this is possible.
you need to create a new table with the following DAX
number of projects = GENERATESERIES(1,100,1)
this will generate a column with 1 to 100 in the cells
Then add a column with
Number of Clients = COUNTAX(FILTER(projects,projects[client ID]='number of projects'[Value]),projects[client ID] = 'number of projects'[Value])
you will end up with a table with 2 columns, a list of how many clients could be attached to a project and how many time that happens. So:
1 client attached = 2 projects
2 clients attached = 2 projects
3 clients attached = 0 projects
etc
Then you can create your visual.
If this solves your issue please mark this as the solution :)
hi!,
after thinking about it a little bit more i attempted the solution you provided from a different angle,
first i created a calculated collumn counting how many occurrences of each company register exists in the projects table. then i used the new collumn as the one to compare with the generated table.
thank you so much!!!.