% Completion Scorecard (No measures in Table)

[adarshalok]

Hi Everyone, 

I'm pretty newbie to Power BI and try to viz a scorecard. 

I have a 3 tables which are merged together using JOINS. 

Table 1	Table 2	Table 3
Application Name	Application Name	Application Name
Status	Status	Status
Category	Category	Category

Table 1 is master table containing apps in Table 2 & 3 (Split based on Category)

I would like to calculate something like % Completion (Scorecard). 

Something like (App with Status Completed from Table 1 + App with Status Completed from Table 2) / Total App (Table 1)

PS: Table doesn't have any measures. 

Any help would be really appreciated.

[Dhacd · Accepted solution]

Good day @adarshalok 
Try the below measure

VarTable1Statustrue=Calculate(countrows(table1),table[status]=true)
VarTable2Statustrue=Calculate(countrows(table2),table[status]=true)
Var result = (VarTable1Statustrue+VarTable2Statustrue)/countrows(table1)

If the measure works for you please mark this as the solution so others can also find it.
Regards,

Atma