Forum Discussion
Helper VHow to count the Meaasure Numbers
Hi RanjanThammaiah ,
You can try this link:
And the row total of each account is in the end of row:
Best Regards,
Yingjie Li
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Community SupportHi RanjanThammaiah ,
You can create the following measure to solve your problem:
Total Number = SUMX(DISTINCT('table'[AccountName]),[Advisory % SLI]+[Assurance % SLI]+[TAS % SLI]+[TAX % SLI])
You will get the result like this:
Here is the demo , please try it:
Best Regards,
Yingjie Li
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Helper VHi,
thanks for the reply. is there anyway we can ge the row total of each Account?
i have ended up with the below error once after i add the formula. and drag that to my table.
All the columns types are in Whole numbers except the account name column.
And i am unable to download the Pbix file.
- v-yingjl
Hi RanjanThammaiah ,
You can try this link:
And the row total of each account is in the end of row:
Best Regards,
Yingjie Li
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.