cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Anonymous
Not applicable

## Calculate percent of none blank cells in one column

Have a column 'ID', there are 413 rows with 399 being populated,  The percentage of non-blank cells is 96.6%.  I want to show this percent in a visulization.

1 ACCEPTED SOLUTION
Super User

Hi @Anonymous

Try this measure an add that to the visuals:

Measure = (count('Table'[ID])-COUNTBLANK('Table'[ID]))/count('Table'[ID])

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

4 REPLIES 4
Super User

Hi,

Drag this measure to a card visual

Measure = divide(count(data[id]),countrows(data))

Format this as a %.

Hope this helps.

Regards,
Ashish Mathur
http://www.ashishmathur.com
Community Support

Hi @Anonymous ，

According to your description, here’s my solution.

Measure = DIVIDE(COUNTROWS(FILTER(ALL('Table'),NOT(ISBLANK([ID])))),COUNTROWS('Table'))

Best Regards,
Community Support Team _ kalyj

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

Super User

Hi @Anonymous

Try this measure an add that to the visuals:

Measure = (count('Table'[ID])-COUNTBLANK('Table'[ID]))/count('Table'[ID])

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

Frequent Visitor

@VahidDM - How do we do this if it's multiple columns, let's say 'Table'[Name], 'Table'[Address], 'Table'[Locality] and we want to identify the % of completeness of each within a measure in addition to 'Table'[ID)?

Measure = (count('Table'[ID])-COUNTBLANK('Table'[ID]))/count('Table'[ID])