Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |