Forum Discussion
Total filtered count rows in matrix
Hello,
I have a Total Threshold measure counted as
Thank you in advance.
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.
5 Replies
use CALCULATE and REMOVEFILTERS to calculate the value across all selected items regardless of employee.
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?
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.
Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
hello use below measures
Total Threshold (Selected Period) =
CALCULATE(
DISTINCTCOUNT(Merged[JobID]) / DISTINCTCOUNT(Merged[JobRig]),
ALL(Merged[EmployeeID]) -- Remove employee-specific context (if your matrix has an employee dimension)
)
