Forum Discussion

icturion's avatar
icturion
Resolver II
8 years ago
Solved

countrow value by group

Hi,   The intention is to present the number of examinations per month with the number of times that a study had been supplemented positively with the percentage of the number of positive results i...
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    Hi icturion

     

    Try these MEASURES

     

    Total # of Exams = Calculate(Countrows(TableName),TableName[DESCRIPTION]="Onderzoek-1")


Total # of Positives = Calculate(Countrows(TableName),TableName[DESCRIPTION]="Positief")


%age = [Total # of Positives]/[Total # of Exams]
  • Ashish_Mathur's avatar
    Ashish_Mathur
    8 years ago

    Hi,

     

    Try this

     

    Total # of Exams = Calculate(Countrows(TableName),TableName[DESCRIPTION]="Onderzoek-1"||TableName[DESCRIPTION]="Onderzoek-2")

     

    Hope this helps.

Ashish_Mathur's avatar
Ashish_Mathur
Super User
8 years ago

Hi,

 

Try this

 

Total # of Exams = Calculate(Countrows(TableName),TableName[DESCRIPTION]="Onderzoek-1"||TableName[DESCRIPTION]="Onderzoek-2")

 

Hope this helps.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    8 years ago

    You are welcome.