Forum Discussion
calculation as per count?
I want to calculate achivement, I have some hard coded total number as per state in my spreadsheet, %achivement is calculate by total/number of count of sales (if in a A state for A1 month if sales occured 4 times (as per a person)), then I will divide total/4 for that calculation, can this be calculated?
5 Replies
Probably. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Not clear at all, what you need. In case you need % of sub total, refer :https://community.powerbi.com/t5/Desktop/Percentage-of-subtotal/td-p/95390
Perhaps this should help you amitchandak Greg_Deckler
https://community.powerbi.com/t5/Desktop/How-to-calculate-Achived/m-p/936552#M448690Not really all that helpful. You need to post a few lines of sample data and then the expected output from that sample data. Otherwise all I can tell you is to use COUNTROWS to count how many you have and use SUM or SUMX to get your total and then use DIVIDE to divide the two. You probably will have some FILTER statments in there as well. Can't really tell you one way or the other because I really have no idea what your data looks like, how you are trying to present it, is this one or two or more tables in the data model, what are your relationships between the tables and so on.
