Forum Discussion

m_e_1203's avatar
m_e_1203
Helper II
5 years ago
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 ...
Need Help
  • m_e_1203's avatar
    m_e_1203
    5 years ago

    Hi v-lionel-msft 

    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.

     

     

CNENFRNL's avatar
CNENFRNL
Community Champion
5 years ago

m_e_1203 , Highly likely that the issue results from filter propagation in your data model given that different columns were referenced in your measures. You'd better attach a dummy file so that it's much easier to troubleshoot.