How to create a dynamic measure to calculate blank count for each column

[SriKandimalla]

Hello Power BI community,

I have a table with bunch of columns. I have referenced my source and unpivoted them, and loaded into desktop to form a relation. I tried Tabe.Profile() in the query editor, but it is not dynamic. I want to show blank % for each column in a table visual and the values should be dynamic when a slicer selection is made. I went thru multiple trail and errors but still no luck.

I really appreicate if anyone can shoot some thoughts 🙂

Thanks in advance

[Greg_Deckler · Accepted solution]

@SriKandimalla - So, you should be able to do this:

Blank % Measure =
  DIVIDE
    COUNTROWS(FILTER('Table',ISBLANK([Column]) || [Column]="")),
    COUNTROWS('Table')
  )

[amitchandak]

@SriKandimalla , Try a new measure like

divide(COUNTBLANK(Table[Column), countrows(Table))