Forum Discussion
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 XuIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
thank you for your help but it did not solve my issue as i need filters as well.
The total Threshold is counted based on the rows selected between the dates. I want to calculate the bonus amount using the 4.4 value for each employee, how do I do that?
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.