cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Helper III

## A measure OR calculated column to work our how man cells have no data

My project involves me working out poor our data is,  We would like to work out how much info has not being entered. We then want express this as percentage per row

Example data:

Animal - Name - Cost - Date

Dog      Danny    \$50  - 1/1/2018     =  0%    Empty

Dog        null      \$50     null              =  50 % Empty

Dog        null      null     null              =  75%  Empty

I have played around with caluclated feilds and measures doing simple things but NOTHING like this.

All I can think is something like a variable -  like If Animal =null then Row Empty = +1,  and then repeat something like this for each cell. From the Row empty value i could write a foumula to convert it into a percentage easily enough but I am stumped on everything before that.

Any ideas, pointers, or simple examples would be most welcome.

1 ACCEPTED SOLUTION
Helper II

I'd create a column

_HowManyAreBlank= IF(ISBLANK([ANIMAL]), 1, 0) + IF(ISBLANK([NAME]), 1, 0) + IF(ISBLANK([COST]), 1, 0) + IF(ISBLANK([DATE]), 1, 0)

This would allow you to create a measure that works for rows, groups, and filters.

Helper II

I'd create a column

_HowManyAreBlank= IF(ISBLANK([ANIMAL]), 1, 0) + IF(ISBLANK([NAME]), 1, 0) + IF(ISBLANK([COST]), 1, 0) + IF(ISBLANK([DATE]), 1, 0)

This would allow you to create a measure that works for rows, groups, and filters.

Announcements

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

#### Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

#### Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors