Forum Discussion

RanHo's avatar
RanHo
Helper V
1 year ago
Solved

How to get number/count with multiple filter

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
    
IDNAMESTATUS DESCRIPTIONCLAIMS CODE
1001

Sylvia

ReleaseST-0031
1002

Gerry

EvaluationST-0032
1003

Trevor

ReviewST-0033
1004

Oli

NewST-0034
1005

Raynard

EvaluationST-0035
1006JohnEvaluationST-0036
1007HughieEvaluationST-0037
1008AnnieNewST-0038
1009SteveEvaluationST-0039
1010MarkEvaluationST-0040
1011PeterNewST-0041
1012GregEvaluationST-0042
1013CliffordEvaluationST-0043
1014JeanEvaluationST-0044
1015ChadEvaluationST-0045

 

 

EVALUATION TABLE
   
IDCLAIMS IDEVALUATION STATUS
71111002APPROVED
71121005APPROVED
71131006PENDING
71141007REJECTED
71151009APPROVED
71161010REJECTED
71171012APPROVED
71181013APPROVED
71191014PENDING
71201015REJECTED


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

4 Replies