cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
singhv2
Helper I
Helper I

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
GabrielSantos
Resolver I
Resolver I

Try these series of measures.

 

CountY =: Countrows ( 

                                      Filter ( Table,

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

                                     )

 

CountTransactions =: Countrows ( Table )

 

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

 

 

View solution in original post

2 REPLIES 2
GabrielSantos
Resolver I
Resolver I

Try these series of measures.

 

CountY =: Countrows ( 

                                      Filter ( Table,

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

                                     )

 

CountTransactions =: Countrows ( Table )

 

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

 

 

Thanks Gabriel.

Helpful resources

Announcements
Vote for T-Shirt Design

Power BI T-Shirt Design Challenge 2023

Vote for your favorite t-shirt design now through March 28.

March 2023 Update3

Power BI March 2023 Update

Find out more about the March 2023 update.

March Events 2023A

March 2023 Events

Find out more about the online and in person events happening in March!

Top Solution Authors