Forum Discussion

CH-BsAs's avatar
CH-BsAs
Frequent Visitor
8 years ago

Countrows with two conditions in different tables

I have a table with services that are performed in x amount of time (Time [response]) and I have anothe table with color codes (Services [color]) where each one has a time limit of response. R = 5...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi CH-BsAs,

 

Maybe you can try to use below measure to calculate total row count:

 

Color Count =
COUNTROWS ( FILTER ( ALL ( Time ), [color] = "R" && [response] > 5 ) ) //R
 + COUNTROWS ( FILTER ( ALL ( Time ), [color] = "Y" && [response] > 10 ) ) //Y
 + COUNTROWS ( FILTER ( ALL ( Time ), [color] = "G" && Time[response] > 15 ) )//G

 

Regards,

Xiaoxin Sheng

CH-BsAs's avatar
CH-BsAs
Frequent Visitor
8 years ago

Thank you for your help Xiaoxin,

 

The problem I have is that the data is located in two different tables.

I think I did not explain myself the lasta time, since I see your formula is not taking that into account.

 

one table is TIME with the RESPONSE field (how long it takes to respond to the case)
and the other table is SERVICES with the field COLOR (type of service)

 

what I have to do is, according to the standard of each service (in my first post) to count those that were exceeded and add them to all in a final record.

 

there is any way to adapt your formula to two diferente tables?

thank you very much!

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    HI CH-BsAs

     

    Can you please provide table structure and relationship between these tables? (share some some sample data and expected result will help for testing and coding formula)

     

    Regards,

    Xiaoxin Sheng