Forum Discussion
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
Community 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