Forum Discussion

niels_vngi's avatar
niels_vngi
Frequent Visitor
4 years ago
Solved

Compare counts from two different tables

Dear all,   We're working on a large household survey that is aimed to map the priorities of citizens. We store general information like age, gender, source of livelihood, etc in one table and stor...
Need Help
  • daniel79's avatar
    daniel79
    4 years ago

    You can try something like this

     

    Households% = 
if(
countx(priorities,priorities[What is the priority?])>countrows(filter(ALLSELECTED('CRC household survey'),'CRC household survey'[B00 Are you able to conduct the survey at this household?]="Yes")),1,
countx(priorities,priorities[What is the priority?])/countrows(filter(ALLSELECTED('CRC household survey'),'CRC household survey'[B00 Are you able to conduct the survey at this household?]="Yes")))
niels_vngi's avatar
niels_vngi
Frequent Visitor
4 years ago

Dear daniel79,

 

First of all my apologies for my late response, there was some off time in between. Secondly, thank you very, very much for providing this solution. Works like a charm! ðŸ‘Œ

 

All the best and kindest regards,

 

Niels