cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
emudria Member
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

2018-08-13 16 58 14.png

Any help in this regard would be extremely helpful and appriciated.

Thanks & regards

emudria.

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Counting items within a category - Dax

@emudria

 

See file attached

 

ciw.png

5 REPLIES 5
Super User
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
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
Super User

Re: Counting items within a category - Dax

@emudria

 

See file attached

 

ciw.png

emudria Member
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
Super User

Re: Counting items within a category - Dax

@emudria

 

Hi

 

What is meant by rolling?

 

Helpful resources

Announcements
Virtual Launch Event

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

Power BI Helps Homeless and Trouble Youth

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

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 119 members 2,002 guests
Please welcome our newest community members: