Forum Discussion
Solved
Count of Total Rows Using Filter Function Based on the Value of Multiple Measures
Plase see the screenshot below. Could someone please tell me how to correct the DAX to make the table visual result match the card visual result? Card visual result should show "1" for this scenario....
You can refer to the following mesaure
Total CV Inc W/O EAC Inc = VAR test = SUMMARIZE ( ALLSELECTED ( Project ), [Project #] ) RETURN COUNTROWS ( FILTER ( test, [Total CV Change] > 0 && [Total EAC Change] <= 0 && SUM ( Project[Total Actual Cost] ) <> 0 ) )Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
You can refer to the following mesaure
Total CV Inc W/O EAC Inc =
VAR test =
SUMMARIZE ( ALLSELECTED ( Project ), [Project #] )
RETURN
COUNTROWS (
FILTER (
test,
[Total CV Change] > 0
&& [Total EAC Change] <= 0
&& SUM ( Project[Total Actual Cost] ) <> 0
)
)
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you so much Yolo! This is exactly what I was looking for.