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.

veenashenolikar's avatar
veenashenolikar
Helper V
5 years ago

hi Anonymous ,

 

The Jobs Cnt3 (excl No purchase) measure is returning the count of rows.. not sum of purchase amount. 

Can you elaborate what exactly do you want Jobs Cnt3 (excl No purchase) measure to return?

 

Thanks,

Veena

  • Anonymous's avatar
    Anonymous
    Not applicable
    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.