cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
singhv2 Regular Visitor
Regular Visitor

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 division, out of the total transaction each does.

 

Need to check, what percentage of each division is a Y, and then Percentage of Y in total out of the total description

 

DivisionDescrption (Say Anythin)If Nomenclature Rule Followed in Description
AasdasdY
BsdfsdfdsN
CfgjfghN
AerwerY
BwerwerY
CfjhfgjN
1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
GabrielSantos Regular Visitor
Regular Visitor

Re: Calculate Percentage

Try these series of measures.

 

CountY =: Countrows ( 

                                      Filter ( Table,

                                                    Table1[Column Yes or No] = "Y")

                                     )

 

CountTransactions =: Countrows ( Table )

 

%Y =: Divide ( [CountY], [CountTransactions])

 

 

2 REPLIES 2
Highlighted
GabrielSantos Regular Visitor
Regular Visitor

Re: Calculate Percentage

Try these series of measures.

 

CountY =: Countrows ( 

                                      Filter ( Table,

                                                    Table1[Column Yes or No] = "Y")

                                     )

 

CountTransactions =: Countrows ( Table )

 

%Y =: Divide ( [CountY], [CountTransactions])

 

 

singhv2 Regular Visitor
Regular Visitor

Re: Calculate Percentage

Thanks Gabriel.