Calculate percent of none blank cells in one column

[Anonymous]

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.

[Ashish_Mathur]

Hi,

Drag this measure to a card visual

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

Format this as a %.

Hope this helps.

[v-yanjiang-msft]

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.

[VahidDM · Accepted solution]

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.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/

[SM321]

@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])