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.

     

     

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.