Forum Discussion

SamBrown17's avatar
SamBrown17
Icon for Helper I rankHelper I
3 years ago

How to calculate Conversion

Hi Team,   I have a business where I make revenue from Works jobs. and I get the works job through either an assessment or a tender. which if created within a project.  So in one project I will hav...
devanshi's avatar
devanshi
Icon for Helper V rankHelper V
3 years ago

Assessment = COUNTROWS([ProjectID] , FILTER('Tablename', Assessment[ProjectID] = Works[projectID]))
Tender  = COUNTROWS([ProjectID] , FILTER('Tablename', Tender[ProjectID] = Works[projectID]))
 
Total works = Assessment + Tender

SamBrown17's avatar
SamBrown17
Icon for Helper I rankHelper I
3 years ago

I am not able to make this work at all sorry. The table name is 'jobs' if that helps but I am unable to use this DAX.