Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
I want my card to show the sum of the completed column for the latest date available. Here is the data:
Date | Type | Completed (New) |
2021-04-15 | Credit | 0 |
2021-04-15 | Financial Rejects | 50 |
2021-04-15 | Non-Financial Rejects | 100 |
2021-04-15 | DQ003 | 10 |
2021-04-15 | iService | 5 |
2021-05-03 | Credit | 30 |
2021-05-03 | Financial Rejects | 100 |
2021-05-03 | Non-Financial Rejects | 200 |
2021-05-03 | DQ003 | 5 |
2021-05-03 | iService | 5 |
2021-05-17 | Credit | 100 |
2021-05-17 | Financial Rejects | 150 |
2021-05-17 | Non-Financial Rejects | 250 |
2021-05-17 | DQ003 | 2 |
2021-05-17 | iService | 5 |
2021-06-01 | Credit | 60 |
2021-06-01 | Financial Rejects | 40 |
2021-06-01 | Non-Financial Rejects | 100 |
2021-06-01 | DQ003 | 6 |
2021-06-01 | iService | 5 |
2021-06-14 | Credit | 50 |
2021-06-14 | Financial Rejects | 55 |
2021-06-14 | Non-Financial Rejects | 100 |
2021-06-14 | DQ003 | 12 |
2021-06-14 | iService | 10 |
Here is what I do right now but the value showing in my card isnt the right one.
With how I did it, the result showing on my card is 687 while it should show 227 (the sum of the data for the latest date 14-06-2021.
Solved! Go to Solution.
Hi, @Whoule
Please check the below picture.
Please try to filter it by Date Column, not by Completed column.
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Linkedin: https://www.linkedin.com/in/jihwankim1975/
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Hi, @Whoule
Please check the below picture.
Please try to filter it by Date Column, not by Completed column.
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Linkedin: https://www.linkedin.com/in/jihwankim1975/
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
You can create a measure using the following formula and use it as the value in the card. you don't have to put any filters
Proud to be a Super User!
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
117 | |
101 | |
71 | |
61 |