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...
Need Help
Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
8 years ago

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's avatar
    Anonymous
    Not applicable
    8 years ago

    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?

    • Zubair_Muhammad's avatar
      Zubair_Muhammad
      Community Champion
      8 years ago

      Anonymous

       

      Hi

       

      What is meant by rolling?