Percentage of Column

[Anonymous]

New to DAX here and I am having trouble with a formula. IF I have one column like below how could I calculate the the count of Y by the total count of All.  So I would like to calculate that the selected value by the total value. ( 1 Yes)/ (4) = .25

Column Name: Y/N

Y

N

N

N

[v-kelly-msft]

Hi @Anonymous ,

You can create a measure as below:

Measure = 
var a =CALCULATE(COUNTROWS('Table'),FILTER(ALL('Table'),'Table'[Column Name: Y/N]="Y"))
var b=COUNTROWS(ALL('Table'))
Return
IF(MAX('Table'[Column Name: Y/N])="Y",DIVIDE(a,b),BLANK())

You can just return :  DIVIDE(a,b) , but if you just wanna show the rows which contain "Y",use the measure above,and you will see:

Or you can create a calculated column as below:

Column = 
var a =CALCULATE(COUNTROWS('Table'),FILTER('Table','Table'[Column Name: Y/N]="Y"))
Return
IF('Table'[Column Name: Y/N]="Y",DIVIDE(a,COUNTROWS('Table')),BLANK())

And you will see:

For the related .pbix file,pls click here.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[amitchandak]

@Anonymous 

% = divide(count(Table[Column], Table[Column]="Y"),count(Table[Column]))

OR
% = divide(count(Table[Column], Table[Column]="Y"),calculate(count(Table[Column]),allselected(Table)))

[TD21 · Accepted solution]

A few ways to do this, one of which is creating 3 separate measures:

M_TOTAL = COUNT(Table[Column])

M_YES = CALCULATE ( COUNT(Table[Column]) , Table[Column] = "Y" )

M_YES_PERCENT = DIVIDE ( [M_YES] , [M_TOTAL] )