Forum Discussion
Percentage calculation
Hi,
I am having 3 fields as below trying to calculate the talatal and % of those, i tried some thing need help.
| keys | Number of Accounts PER USER | user Name |
| F39F7626BB2F2B7712EDA1BFADB11 | 30 | [email protected] |
| 73D741DF314F7CE3CA1578265EE71 | 30 | [email protected] |
| 135D81AC4C1BE99135A56F5154DF2 | 0 | [email protected] |
| DFA72892728DE9AC4D6A1C7FF12CD | 20 | [email protected] |
| 862A1DEE374CC7C3AA289626CE368 | 715 | [email protected] |
| 9CA543A4F2ABB28575CACEE76CA87 | 40 | [email protected] |
| 468A53332D45B539F5395E2F29DC5 | 4 | [email protected] |
| 2E656AD1228FEAB62C431BC5DB72C | 40 | [email protected] |
| 2ACF9AFAD4CC6CC8477C35C95EA4A | 10 | [email protected] |
| F49A941443A925357E3C849B8D92E | 4 | [email protected] |
Fisrt identifying the count of keys i did add a new measure with a formula-- KeyCount = count(Keys) for calculating the percentage used the formula Key % = divide(count(Keys),sum(Manually entered values in a column-"10" and called here ),0). i want the field to be filled with 10 automatically. Same i calclulate for the rest that is user and no of users by manually updateing the value in a column and used as a denominator.
How to get rid of manulally updating.please suggest.
2 Replies
Hi Shankar12v,
You could use dax formula to replace the sum (10).
If the number 10 is the sum rows of Key, you could use dax function COUNTROWS to calculate it. Then you don't need to manually update it. It will change dynamically with the total key rows.
Best Regards,
Cherry
Hi Shankar12v,
Have you solved your problem?
If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.
If you still need help, please share your desired output so that we could help further on it.
Best Regards,
Cherry
