create a Measure based on filtering database for each item

[pierre-yves]

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 .

would have any idea how to do this with powerBI ?

thank you for your support 

project	company	activity	measure
project1	company1	activity1	2
project2	company1	activity2	1
project3	company2	activity1	3
project4	company2	activity1	3
project5	company1	activity1	2
project6	company2	activity1	3

[m3tr01d]

hello @pierre-yves,
what about 

CALCULATE(
   COUNTROWS( 'Table' ),
   ALLEXCEPT( 'Table', 'Table'[Activity], 'Table'[Company] )
)

[pierre-yves]

table in different format 

[pierre-yves]

Hi Community 

I m just following up on this request

anyone have any idea on how to adress this issue

thank you for your support

[pierre-yves]

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

...