Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Reply
steambucky
Helper III
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
Ormesome
Helper II
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.

 

View solution in original post

1 REPLY 1
Ormesome
Helper II
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.

 

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.