Percentage calculation

[Shankar12v]

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	shancv@gmail.com
73D741DF314F7CE3CA1578265EE71	30	pranku@gmail.com
135D81AC4C1BE99135A56F5154DF2	0	Aprilv@gmail.com
DFA72892728DE9AC4D6A1C7FF12CD	20	vegavd@gmail.com
862A1DEE374CC7C3AA289626CE368	715	fontyv@gmail.com
9CA543A4F2ABB28575CACEE76CA87	40	Mergecv@gmail.com
468A53332D45B539F5395E2F29DC5	4	formvre@gmail.com
2E656AD1228FEAB62C431BC5DB72C	40	epicnvf@gmail.com
2ACF9AFAD4CC6CC8477C35C95EA4A	10	rapnd@gmail.com
F49A941443A925357E3C849B8D92E	4	lectnvk@gmail.com

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.

[v-piga-msft]

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

[v-piga-msft]

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