calculation as per count?

[Anmolgan]

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?

[amitchandak]

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

[Anmolgan]

Perhaps this should help you @amitchandak  @Greg_Deckler  

https://community.powerbi.com/t5/Desktop/How-to-calculate-Achived/m-p/936552#M448690

[Greg_Deckler]

Not 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.

[Anmolgan]

@Greg_Deckler  Sure I can give you sample data and sample output, please check your private chat.

[Greg_Deckler]

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