Forum Discussion

singhv2's avatar
singhv2
Icon for Helper I rankHelper I
9 years ago
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...
Need Help
  • GabrielSantos's avatar
    GabrielSantos
    9 years ago

    Try these series of measures.

     

    CountY =: Countrows ( 

                                          Filter ( Table,

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

                                         )

     

    CountTransactions =: Countrows ( Table )

     

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

     

     

GabrielSantos's avatar
GabrielSantos
Icon for Resolver I rankResolver I
9 years ago

Try these series of measures.

 

CountY =: Countrows ( 

                                      Filter ( Table,

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

                                     )

 

CountTransactions =: Countrows ( Table )

 

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

 

 

  • singhv2's avatar
    singhv2
    Icon for Helper I rankHelper I
    8 years ago

    Thanks Gabriel.