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()))

Ashish_Mathur's avatar
Ashish_Mathur
Super User
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()))

Thomas_S's avatar
Thomas_S
Frequent Visitor
3 years ago

The first one works perfectly ! Thank you !

(the second measure return "empty" on the card)

 

Last question, for my understanding, why is it working with a double "=" sign in the measure? What does it mean ?