Total filtered count rows in matrix

Hi nidhs909 

Thanks for the reply from lbendlin and Laxmanjatoth .

Here is the test I did for your reference.

My sample:

Create a measure as follows

Threshold = 
CALCULATE(
    DISTINCTCOUNT(Merged[JobID]) / DISTINCTCOUNT(Merged[JobRig]),
    ALLSELECTED(Merged)
)

Output:

If the above does not solve your problem, as lbendlin said, we need example data and desired results based on the example data to better help you. Please remove any sensitive data in advance.

Best Regards,
Yulia Xu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.