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.

  • v-lionel-msft's avatar
    v-lionel-msft
    Community Support
    5 years ago

    Hi m_e_1203 ,

     

    Like this?

    I think you just need to compare the [Total Sales] column with the [Target Amount] column.
    But I'm not sure what you want to do with the row where [Target Amount]=0 or blank.

     

    Best regards,
    Lionel Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • m_e_1203's avatar
      m_e_1203
      Helper II
      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.