How to get number/count with multiple filter

[RanHo]

Good day!

       I have a problem here, need advice or idea on how to get with dax or column.
Here's my sample table data:

CLAIMS TABLE
ID	NAME	STATUS DESCRIPTION	CLAIMS CODE
1001	Sylvia	Release	ST-0031
1002	Gerry	Evaluation	ST-0032
1003	Trevor	Review	ST-0033
1004	Oli	New	ST-0034
1005	Raynard	Evaluation	ST-0035
1006	John	Evaluation	ST-0036
1007	Hughie	Evaluation	ST-0037
1008	Annie	New	ST-0038
1009	Steve	Evaluation	ST-0039
1010	Mark	Evaluation	ST-0040
1011	Peter	New	ST-0041
1012	Greg	Evaluation	ST-0042
1013	Clifford	Evaluation	ST-0043
1014	Jean	Evaluation	ST-0044
1015	Chad	Evaluation	ST-0045

EVALUATION TABLE
ID	CLAIMS ID	EVALUATION STATUS
7111	1002	APPROVED
7112	1005	APPROVED
7113	1006	PENDING
7114	1007	REJECTED
7115	1009	APPROVED
7116	1010	REJECTED
7117	1012	APPROVED
7118	1013	APPROVED
7119	1014	PENDING
7120	1015	REJECTED

1ST: Get the Claims with the status "evaluation" and
2nd: That claims get all the evaluation count in evaluation table with status either approved, pending or rejected.

Result:
1. put the count on cards
2. List of count on table visual. (if possible)


Thanks in advance!

~RAN

[elitesmitpatel · Accepted solution]

Hey @RanHo 
I have calculated the values according to the requirements , please download the file and have a look

PBIX file for reference
How to get number/count with multiple filter Solution 

If it help please Kudos the work and Accept it as solution 

[RanHo]

@elitesmitpatel Thanks a lot.

[Ashish_Mathur]

Hi,

Show the expected result very clearly.

[RanHo]

Sorry my bad, but I just want to get the count with cards, and also if it's possible will it be able to put on table the list of that count?