Forum Discussion
create a Measure based on filtering database for each item
Hi community, I have a database with list of project/company and activity and I would like to make a measure that count the qty of projects with the same company and activity as below table . ...
table in different format
to clarify the result of the table:
line 1: qty of projects with company1 and activity1=2
line 2: qty of projects with company1 and activity2=1
line 3: qty of projects with company2 and activity1=3
...