Forum Discussion
how to count distinct values in a column
Here is my solution. Not sure it meets your needs exactly, so let me know if you need more help.
Key formula for % of total: Percent of Total Balance = Sum(Sheet1[Balance])/Calculate(Sum(Sheet1[Balance]),All(Sheet1))
You can use the Acct. dimension i Pie Chart. Then, create a new Measure, and use the formula above to create % of Total. This works because your individual Balance entries sum to the Total Balance. You don't actually need the Total Balance column, or the Count of Rows for this.
If you want the PBIX file and my data source, let me know and I can email it to you, or something.
Nate
The Sum of the balances of all the accounts together does equal the Total Balance. This is what I was able to get so far using COUNT and creating a TOTAL measure:
Helper VHere is my solution. Not sure it meets your needs exactly, so let me know if you need more help.
Key formula for % of total: Percent of Total Balance = Sum(Sheet1[Balance])/Calculate(Sum(Sheet1[Balance]),All(Sheet1))
You can use the Acct. dimension i Pie Chart. Then, create a new Measure, and use the formula above to create % of Total. This works because your individual Balance entries sum to the Total Balance. You don't actually need the Total Balance column, or the Count of Rows for this.
If you want the PBIX file and my data source, let me know and I can email it to you, or something.
Nate
Hi Nate,
Would you kindly email me your PBIX file and data source? I'll send you my email via private message.
Thanks
-Tina