Count how many IDs meet two requirements

Question

Nice dayI require your help as I want to count in a table that brings ID and for each ID many answers from these cules ID meet two specific answersThis is the table that contains the IDs and responses.and this is the specific answers that must be found, for example from the previous table how many response IDs walamrt have in c4 and automercado in c1.5 and so on with each of the rows in this second tableI leave an example GDP  https://drive.google.com/file/d/1RL-iWsD5yiWLTT7dSRP48O9IZn-8Wklk/view?usp=drive_link

anonymous · Answer

Hi&nbsp;Syndicate_Admin&nbsp;
&nbsp;
Please provide more detailed description.
Actually that I can't understand the requirement that you post completely.
If possible, please provide&nbsp;your expected result with backend logic and special examples.
&nbsp;
Best Regards
Zhengdong XuIf this post&nbsp;helps, then please consider&nbsp;Accept it as the solution&nbsp;to help the other members find it more quickly.

ryan_mayu · Answer

Syndicate_Admin&nbsp;
the link can't open.
Do you mean, if an SbjNum's PERCEPCION(Estudio) has both C1.5 and C4, that ID count as 1?
what's the expected output based on the sample data you provided?
&nbsp;

3xotic · Answer

Each combination found in the first table would be counted as 1, and each combination that is required is described in table 2.&nbsp;For example, if the id "203522243" in all your answers is c4 walmart and c1.5 automercado it would be considered 1&nbsp;The result is presented in a table like this, being the advance counts combinations found&nbsp;

3xotic · Answer

Each combination found in the first table would be counted as 1, and each combination that is required is described in table 2.&nbsp;For example, if the id "203522243" in all your answers is c4 walmart and c1.5 automercado it would be considered 1&nbsp;The result is presented in a table like this, being the advance counts combinations found&nbsp;&nbsp;

Forum Discussion

Count how many IDs meet two requirements

Related content

Fabric & Azure Data User Group Program Requirements & Benefits

Counting nulls

Slicer requirement

Business Requirement Document Template

update required pipeline