cancel
Showing results for
Did you mean:
Member

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

1 ACCEPTED SOLUTION

Accepted Solutions
Super User

## Re: Counting items within a category - Dax

@emudria

See file attached

5 REPLIES 5
Super User

## Re: Counting items within a category - Dax

@emudria

Try this calculated Column

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

## Re: Counting items within a category - Dax

@emudria

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] )
)```
Super User

## Re: Counting items within a category - Dax

@emudria

See file attached

Member

## Re: Counting items within a category - Dax

Thank you @Zubair_Muhammad, it is giving me the right numbers as long as I have dimensions in the table, ie chain, individual store, month, product - but I cannot roll these numbers. Can I make any change here to roll the numbers?

Super User

## Re: Counting items within a category - Dax

@emudria

Hi

What is meant by rolling?

Announcements

#### Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

#### Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

#### Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 119 members 2,002 guests
Recent signins: