Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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.
Solved! Go to Solution.
@Anonymous
See file attached
@Anonymous
Try this calculated Column
Count of Total Stores in each Chain = CALCULATE ( DISTINCTCOUNT ( Table1[individual store] ), ALLEXCEPT ( Table1, Table1[store chain name] ) )
@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] ) )
@Anonymous
See file attached
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?
@Anonymous
Hi
What is meant by rolling?
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
87 | |
87 | |
86 | |
67 | |
49 |
User | Count |
---|---|
134 | |
113 | |
100 | |
68 | |
67 |