Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
Solved! Go to 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
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
Hi,
Show the expected result very clearly.
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?
User | Count |
---|---|
72 | |
66 | |
34 | |
25 | |
22 |
User | Count |
---|---|
96 | |
95 | |
56 | |
45 | |
42 |