How can i get the correct values?

Hi Anonymous 

You could create a new calculated table with only the rows of interest or do it with a visual  and a measure. Let's look at the latter:

1. Place all columns of your table in a table visual (make sure they all are set to "Don't summarize"

2. Create this measure:

ShowMeasure =
VAR Count0_ =
    CALCULATE (
        COUNT ( Table1[Project] ),
        Table1[Active] = 0,
        ALLEXCEPT ( Table1, Table1[Project] )
    )
VAR Count1_ =
    CALCULATE (
        COUNT ( Table1[Project] ),
        Table1[Active] = 1,
        ALLEXCEPT ( Table1, Table1[Project] )
    )
RETURN
    IF ( Count0_ > 0 && Count1_ = 0, 1, 0 )

3. Include  the measure in the visual filter and choose to show when it is 1 

Please mark the question solved when done and consider giving kudos if posts are helpful.

Cheers