Forum Discussion
calculation as per count?
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#M448690
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.
Greg_Deckler Sure I can give you sample data and sample output, please check your private chat.
