Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Filter on Measure

Hi,   I have this measures: Purchase Amount = SUM(Purchases[Amount])   Jobs Cnt3 (excl No purchase) = CALCULATE( COUNTROWS(Job), FILTER(Purchases, CALCULATE([Purchase Amount]) >0) ) and it ...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Sorry for the late reply.

    I figured it out, there was an issue with data, some of there figures were not 0, I had figures like 0.0000000005, so it was not exculding it.

    Thanks for your feedback.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

veenashenolikar I understand it is returning the row count. what I want is to retrun the row count only for job numbers that have Purchases amount =0, the measure Purchases amount is from Purchases table that is joined to the Job table on Job Numbe column.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

what I meant was to not count any Job Number that have Purchase Amount is 0.

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

    Hi  Anonymous ,

     

    Could you pls provide some sample data for test?

     

    Best Regards,
    Kelly

    Did I answer your question? Mark my post as a solution!