Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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 .   ...
m3tr01d's avatar
m3tr01d
Icon for Continued Contributor rankContinued Contributor
5 years ago

hello Anonymous,
what about 

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