Forum Discussion

bdaumPZN's avatar
bdaumPZN
Frequent Visitor
7 years ago
Solved

Dax help - count rows that meet a condition

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.

 

 

  • 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

     

1 Reply

  • v-lili6-msft's avatar
    v-lili6-msft
    Icon for Community Support rankCommunity Support

    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