Forum Discussion
Solved
Filter does not work
Hello, I am trying to count the number of the stores who met the target sales amount. # of Store = CALCULATE(DISTINCTCOUNT(Store[StoreName]), FILTER(Sales, Sales[CustomerID]))
Difference ...
Thank you for checking. There seems to be still not matching data but I could figure out counting different way.
Thanks again for your assitance.
*** Correction ***
Example (Store Group1): Total Store = 5 // # of store reached target = 2 --> This is correct result.
| CY Sales | Target Amount | Difference from Target$ | Store Name |
| $1,203,199 | $600,000 | $603,199 | Store A |
| $248,143 | $210,000 | $38,143 | Store B |
| $0 | $0 | Store C | |
| $0 | $0 | Store D | |
| $11 | ($11) | Store E |