Forum Discussion

jeversf's avatar
jeversf
Frequent Visitor
7 years ago
Solved

Show % Complete Total Only

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.

 

Need Help
  • v-cherch-msft's avatar
    v-cherch-msft
    7 years ago

    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,

3 Replies

  • v-cherch-msft's avatar
    v-cherch-msft
    Microsoft Employee
    7 years ago

    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's avatar
      jeversf
      Frequent Visitor
      7 years ago

      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's avatar
        v-cherch-msft
        Microsoft Employee
        7 years ago

        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,