Table Visual Not Displaying Correctly

[ElvirBotic]

Hello, 

I have a measure to count how many inspections took place YTD. When I do some validation to make sure I am aggregating correctly I end up with the correct number, however when I add the total to a table and drag over a column from my dimension it depicts a misleading total. Example, 

In my data source I show 356 completed inspections YTD and my DAX measure shows the same value. As soon as I add it to a table and add a column to view by property then my are correct, however it is adding a value to properties that were inspected last year. I have two tables. One as a summary count to show how many inspections were done at each property and another table to show details such as when it was completed, by who, score, etc. 

When I select a property that has 3 completed inspections my details table filters and shows they were completed in 2023, but it should be blank and there should be a 0 or blank in the table showing count by property. 

I guess how would I get it to show YTD count by property and have my details table show what is happening for 2024 too? I thoughtit was straightforward, but I guess I am wrong. 

[amitchandak · Accepted solution]

@ElvirBotic , Make sure you are using date table for ytd measure. Field from date table should be used in measure, visual and slicer/filter

examples

YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD('Date'[Date],"12/31"))
Last YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(dateadd('Date'[Date],-1,Year),"12/31"))

refer:

Why Time Intelligence Fails - Powerbi 5 Savior Steps for TI :https://youtu.be/OBf0rjpp5Hw
https://amitchandak.medium.com/power-bi-5-key-points-to-make-time-intelligence-successful-bd52912a5b...
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.