Forum Discussion
Helper ICalculate 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
| Division | Descrption (Say Anythin) | If Nomenclature Rule Followed in Description |
| A | asdasd | Y |
| B | sdfsdfds | N |
| C | fgjfgh | N |
| A | erwer | Y |
| B | werwer | Y |
| C | fjhfgj | N |
Try these series of measures.
CountY =: Countrows (
Filter ( Table,
Table1[Column Yes or No] = "Y")
)
CountTransactions =: Countrows ( Table )
%Y =: Divide ( [CountY], [CountTransactions])
2 Replies
GabrielSantosResolver I
Try these series of measures.
CountY =: Countrows (
Filter ( Table,
Table1[Column Yes or No] = "Y")
)
CountTransactions =: Countrows ( Table )
%Y =: Divide ( [CountY], [CountTransactions])
- singhv2
Thanks Gabriel.