Forum Discussion
Calculate Countrows Issue wrong number displayed
Hi SamuelSea,
As per understanding by reading your original post:The mismatch in numbers 17 vs. 12 is likely due to row context not being properly translated into filter context when using calculated columns and measures together.
Instead of relying on the calculated column Budget Status, use the same logic directly in your measure using variables:Count of Funded Projects =CALCULATE(DISTINCTCOUNT('Research Capital Report'[Project Name]),FILTER(ADDCOLUMNS(VALUES('Research Capital Report'[Project Name]),"TotalBudget", CALCULATE(SUM('Research Capital Report'[Budget Amt]), 'Research Capital Report'[Type ] = "Budget"),"TotalActual", CALCULATE(SUM('Research Capital Report'[Total Amt]), 'Research Capital Report'[Type ] = "Actual")),[TotalActual] < [TotalBudget] && [TotalActual] > 0))
Hope the above DAX expression may help you.Please let me know if you have further questions.
If this reply helped solve your problem, please consider clicking "Accept as Solution" so others can benefit too. And if you found it useful, a quick "Kudos" is always appreciated, thanks!
Best Regards,
Maruthi
LinkedIn - http://www.linkedin.com/in/maruthi-siva-prasad/
X - Maruthi Siva Prasad - (@MaruthiSP) / X
Are the "Total Actual" and "Total Budget" columns also measures? If so something with these might be causing the issue as your budget status measure is accurately assigning the statuses based on your logic you have. Something with how those totals are calculated might be causing the issue. If you post the DAX for those that would help as well.
Another thing you could try to fix your error above is perist your measure in a variable for this code:
The change would be:
Count of Funded T1 =
VAR StatusGo = Research Capital Report[Status Go]
**or if this is not a measure**
VAR StatusGo = SelectedValue(Research Capital Report [Status Go])
RETURN
CALCULATE(
COUNTROWS('Project Summar'),
StatusGo = "Funded")
