Forum Discussion
Andybr
6 years agoFrequent Visitor
Null Count & Percentage
Hi All, I'm an Enterprise Data Architect who's new to PowerBI, I'm used to SQL and excel functions and writing the simplest thing is v. frustrating - any help is most appreciated. I've got a ...
- 6 years ago
Hi Andybr ,
check this.
Measure = DIVIDE(COUNTROWS(FILTER('Table','Table'[Column] = 1234567)),COUNTROWS('Table'))https://docs.microsoft.com/en-us/dax/divide-function-dax
https://docs.microsoft.com/en-us/dax/countrows-function-dax
https://docs.microsoft.com/en-us/dax/filter-function-dax
mwegener
Most Valuable Professional
6 years agoHi Andybr ,
check this.
Measure = DIVIDE(COUNTROWS(FILTER('Table','Table'[Column] = 1234567)),COUNTROWS('Table'))
https://docs.microsoft.com/en-us/dax/divide-function-dax
https://docs.microsoft.com/en-us/dax/countrows-function-dax
https://docs.microsoft.com/en-us/dax/filter-function-dax