Forum Discussion

Thomas_S's avatar
Thomas_S
Frequent Visitor
3 years ago
Solved

Count calculation result

Hello   I'm trying to count the result of a calculated measure but i'm stucked...   I have 2 distinct tables (with many other differents columns, extracted from 2 differents "tools"), looking lik...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    3 years ago

    Hi,

    Try this measure

    Measure = COUNTROWS(FILTER(VALUES(Calendrier[Date]),[Solde]==0))

    or

    Measure = COUNTROWS(FILTER(VALUES(Calendrier[Date]),[Solde]=0&&[Solde]<>blank()))

v-zhangti's avatar
v-zhangti
Community Support
3 years ago

Hi, Thomas_S 

 

Measure:

 

Count = COUNTX(FILTER('Table 1',[Sum3]=0),[Sum3])

Or

Count = COUNTX(FILTER('Table 1',[Sum3]=0),[ID])

 

Is this the result you expect?

 

Best Regards,

Community Support Team _Charlotte

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