Forum Discussion
Solved
Calculate Percentage
I want to calculate the percentage of "Y" (Say in Col 3) mentioned for seperate divisions (Say )1,2,3 (in col 1). Please suggest. My requirement is to get the %age of no. of "Y", by an individual di...
Try these series of measures.
CountY =: Countrows (
Filter ( Table,
Table1[Column Yes or No] = "Y")
)
CountTransactions =: Countrows ( Table )
%Y =: Divide ( [CountY], [CountTransactions])
Try these series of measures.
CountY =: Countrows (
Filter ( Table,
Table1[Column Yes or No] = "Y")
)
CountTransactions =: Countrows ( Table )
%Y =: Divide ( [CountY], [CountTransactions])
Thanks Gabriel.