Dax help - count rows that meet a condition

[bdaumPZN]

I have two tables (plus a dates table)

• Company table – a reference table that has a list of all companies and related information about that company
• Task table – a fact table that has activities that companies have completed. You can think of this as a transaction table.

The company table has fields for location (one is state, the other metro area).  What I need to do is the following:

Find the percentage of companies in a given metro area that have completed at least one task.  I'm trying to do this by counting the rows (companies) that meet the condition of completing a minimum of one task and then dividing by the total number of companies in the metro area.  My code is below and i have include a screen shot of some of the matrix that outline what I'm trying to achieve.  Let me know if you need more information.

[v-lili6-msft · Accepted solution]

hi, @bdaumPZN 

I think if you could keep a few more decimal places for this measure.

For example:

If not your case, please share a simple sample pbix file for us have a test.

Do mask sensitive data before uploading

Best Regards,

Lin