Forum Discussion
Counting items within a category - Dax
Hi Community,
I am stuck with a rather simple looking calculation - but I cannot make any logic towards resolution.
It would be of great help if anyone can please provide any direction.
I am working on a problem, where I got main frenchise company - calling here, store chain name - say {Pizza_Plannet, The_Pizza_Shop ,etc}
then I got list of indivdual store within that chain - say {Pizza_plannet_Sydney, Pizza_plannet_Melbourne, The_Pizza_Shop_Sydney, etc}
then there are certain products which each individual store is selling, like pizza, colddrink, cookie
All I want to know is, within the main company, how many stores are selling each product & the percentage of stores
say only pizza plannet sydney sold cookies , so cookies for pizza plannet will be sold at 50 % of the pizza plannet stores,
while all stores of The_Pizza_Shop are selling cookies, so cookies for The_Pizza_Shop will be 100%.
below is a tabular snapshot
Any help in this regard would be extremely helpful and appriciated.
Thanks & regards
emudria.
Anonymous
See file attached
5 Replies
- Zubair_MuhammadCommunity Champion
Anonymous
Try this calculated Column
Count of Total Stores in each Chain = CALCULATE ( DISTINCTCOUNT ( Table1[individual store] ), ALLEXCEPT ( Table1, Table1[store chain name] ) )- Zubair_MuhammadCommunity Champion
Anonymous
And this one
Count of stores selling a product within each chain = CALCULATE ( DISTINCTCOUNT ( Table1[individual store] ), ALLEXCEPT ( Table1, Table1[store chain name], Table1[Product] ) )- Zubair_MuhammadCommunity Champion