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 ca...
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,

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,