Forum Discussion

Shankar12v's avatar
Shankar12v
Regular Visitor
7 years ago

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 F39F7626BB2F2B7712EDA1BFADB1...
v-piga-msft's avatar
v-piga-msft
Resident Rockstar
7 years ago

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