cancel
Showing results for
Did you mean:

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

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
MVP

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.

MVP

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

Announcements

#### Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

#### Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

#### The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors