Fabric is Generally Available. Browse Fabric Presentations. Work
towards your Fabric certification with the Cloud Skills Challenge.
I want my card to show the sum of the completed column for the latest date available. Here is the data:
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.
Go to Solution.
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.
View solution in original post
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
Check out the November 2023 Power BI update to learn about new features.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.