Help on preventing count on a blank cell

Question

Hi, I currently have the below metric which counts the number of rows containing 1 and shows as a percentage, e.g. if there are 31 rows and 16 contain 1, the measure will count that there are 31 and say 52% of the rows contain 1.&nbsp;&nbsp;My only issue with this is i don't want the measure to tally empty rows:&nbsp;Dpt:Score:Hair1Beauty0Skincare1Products&nbsp;Face1&nbsp;The above example should return 75% as it only counts the 1's and 0's, calculating the number of 1's from the count.The blank cell for products is not counted. How can i reflect this in the below measure?&nbsp;Dec % Per Dpt = DIVIDE(CALCULATE( COUNTROWS('Dept Scorecard 2122'), 'Dept Scorecard 2122'[Dec_6] = 1 ),&nbsp;CALCULATE( COUNTROWS('Dept Scorecard 2122'), ALL('Dept Scorecard 2122'[Dec_6]&nbsp;)))

amitchandak · Accepted Answer

jonbox , try a measure like 
&nbsp;
Dec % Per Dpt =DIVIDE(CALCULATE( COUNTROWS('Dept Scorecard 2122'), 'Dept Scorecard 2122'[Dec_6] = 1 ), CALCULATE( COUNTROWS('Dept Scorecard 2122'), Filter(ALL('Dept Scorecard 2122'[Dec_6] ), not(isblank('Dept Scorecard 2122'[Dec_6])))))

Forum Discussion

Related content

Counting Non-Blank Records

Counting nulls

How to count blank record and un-blank record using DAX in filter Calculations

COUNT NOT BLANK

Counting blanks