Show % of cells with data per table row.

[StuartSmith]

I have a table visual with multiple colums containg "Text", "Numerical" data, etc. and would like to show a coulmn that shows a % data bar of cells that contain data.  How can this be done? Thanks in advance.

Name	Country	City	Age	Completed
Sid Snot	UK	London	45	100%
John Doe		New York		50%
Jane Doe	Spain	Madrid		75%
Micky Mouse				25%
Buck Rodgers	US	Washington	22	100%

[StuartSmith]

Anyone? 🙂

[v-yinliw-msft · Accepted solution]

Hi @StuartSmith ,

You can try this method:

Add a index column, and add these columns:

isnotblankA =
IF (
    CALCULATE (
        MAX ( 'Table'[Age] ),
        FILTER ( 'Table', 'Table'[Index] = EARLIER ( 'Table'[Index] ) )
    )
        = BLANK (),
    0,
    1
)

isnotblankCity =
IF (
    CALCULATE (
        MAX ( 'Table'[City] ),
        FILTER ( 'Table', 'Table'[Index] = EARLIER ( 'Table'[Index] ) )
    )
        = BLANK (),
    0,
    1
)

isnotblankCoun =
IF (
    CALCULATE (
        MAX ( 'Table'[Country] ),
        FILTER ( 'Table', 'Table'[Index] = EARLIER ( 'Table'[Index] ) )
    )
        = BLANK (),
    0,
    1
)

isnotblankN =
IF (
    CALCULATE (
        MAX ( 'Table'[Name] ),
        FILTER ( 'Table', 'Table'[Index] = EARLIER ( 'Table'[Index] ) )
    )
        = BLANK (),
    0,
    1
)

 Then new a measure:

Completed =
SUMX (
    SUMMARIZE (
        'Table',
        'Table'[isnotblankN],
        'Table'[isnotblankCoun],
        'Table'[isnotblankCity],
        'Table'[isnotblankA]
    ),
    'Table'[isnotblankA] + 'Table'[isnotblankCity] + 'Table'[isnotblankCoun] + 'Table'[isnotblankN]
) / 4

The result is:

Hope these help you.

Here is my PBIX file.

Best Regards,

Community Support Team _Yinliw

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[StuartSmith]

That worked great 🙂 I was trying to get it working in 1 measure, instead of mutiple measures, etc.