Count of Total Rows Using Filter Function Based on the Value of Multiple Measures

[InfiniteSheldon]

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. I have also attached the PBI file. 

https://www.dropbox.com/s/x6pt0s36yc2oci5/Filter%20Function.pbix?dl=0

Basically, what is wrong witht the DAX below?

Total CV Increase W/O EAC Increase where there is incurred cost =

CALCULATE(

    COUNT(Project[Project #]),

    FILTER(Project,

    Project[Total Actual Cost] <> 0 &&

    [Total CV Change] > 0 &&

    [Total EAC Change] <= 0

    )

)

[v-xinruzhu-msft · Accepted solution]

Hi @InfiniteSheldon 

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.

[InfiniteSheldon]

Thank you so much Yolo! This is exactly what I was looking for.