Show % Complete Total Only

[jeversf]

Hi All,

Can someone tell me how to show the total % complete in the attached (highlighted yellow) and not the ones marked with a red cross please.

I used the following code in a measure to calculate the % complete for each row:

QVD%Complete = DIVIDE(CALCULATE(COUNT('MC Plus'[Status]),FILTER('MC Plus','MC Plus'[Status]="Complete")),[QVD Count])

all I need to do now is show the total % complete column without the other columns automatically being applied.

Would love to hear if there is a simpler solution too.

Thanks in advance.

[v-cherch-msft]

Hi @jeversf 

You may try to use below measure:

Measure =
DIVIDE (
    CALCULATE (
        COUNT ( 'MC Plus'[Status] ),
        FILTER ( 'MC Plus', 'MC Plus'[Status] = "Complete" )
    ),
    CALCULATE ( [QVD Count], ALL ( 'MC Plus'[Status] ) )
)

Regards,

[jeversf]

@v-cherch-msft 

Hi Cherie,

Thanks for the response. The issue I'm having isn't so much with the formula, it's with the % column. I just want to show the right most % column (highlighted yellow) and not the two in the middle (marked with a red "X").

[v-cherch-msft · Accepted solution]

Hi @jeversf 

You may change the measure as below to show them as blank.

Measure =
IF (
    ISFILTERED ( 'MC Plus'[Status] ),
    BLANK (),
    DIVIDE (
        CALCULATE (
            COUNT ( 'MC Plus'[Status] ),
            FILTER (  'MC Plus', 'MC Plus'[Status] = "Complete" )
        ),
        [QVD Count]
    )
)

Regards,