Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

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.

5 Replies

  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    Community Champion

    Anonymous

     

    Try this calculated Column

     

    Count of Total Stores in each Chain =
    CALCULATE (
        DISTINCTCOUNT ( Table1[individual store] ),
        ALLEXCEPT ( Table1, Table1[store chain name] )
    )