Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Dynamic measure for nonblank rows

I'm trying to create a bar chart with the count of nonblank rows as values and the column headers on the axis.

 

I've created some 'hard-coded' measures that look at each of the columns, e.g.:

 

COUNTBLANK(Planning[Actual_ClosingMeeting])

 

but when charting they are clustered together under a single axis value.

 

I was thinking if I could create a measure that looked at nonblank rows I could chart that and the axis would work as a filter? Perhaps this approach isn't the solution though.

 

Thanks