Need to create measure for summarize count per banner

[Atul8286]

Hi All,

I am trying to create measure for to count the no of stores available per banner, but it will not affect by any filter

for eample please refer following table:

Banner_Name  StoreID    No.of.Stores

East                    1                   5

                           2                  5

                           3                  5

                          4                   5

                          5                  5

West                  1                  2

                         2                  2

Sount                1                  3

                          2                 3

                         3                  3

North               1                  2

                         1                  2

Here, the no of stores should show how many total number of stores available by banner, and will not affect by department column.

Plese help.

[MFelix · Accepted solution]

Hi @Atul8286 ,

You can try has a measure or as a calculated column.

n of store = CALCULATE(COUNT('Table'[StoreID]), ALLEXCEPT('Table','Table'[Banner_Name]))