Time Intelligence Month to Date Totals Issues

[Taffalaffa]

Hi. I am struggling with the month to date time intelligence quick measure.  It is only working for my baseline data dates and not for anything else.  I cannot for the life of me figure out why.  Here is a link to the report:  https://www.dropbox.com/s/vofi22n87wyfvph/Finish%20Date%20Issues.pbix?dl=0 .  It seems like it has to be something really obvious but I just can't find the problem.  Thanks for any help you can provide! @MFelix 

[MFelix · Accepted solution]

Hi @Taffalaffa ,

This has to do with the filters of the table:

Since you are filtering the column Finish BL to not be blank the other two columns don't have any data so that is why you don't have values.

If you clear the filter you will get values

[Taffalaffa]

@MFelix Thank you so much!  I feel like a total bonehead!  Serves me right from copying from a different visual.  I was going crazy trying to figure out the problem.  This is a good lesson learned to double check my flters.  You have helped me so much!  If you are ever in San Diego let me kow! I owe you a drink!

[MFelix]

Hi @Taffalaffa,

It's normal we get so envolved with the visualizations we some time forget to see the basic things. Also happens to me a lot. 

[Taffalaffa]

@MFelix Thank you so much!  I feel like a total bonehead!  Serves me right from copying from a different visual.  I was going crazy trying to figure out the problem.  This is a good lesson learned to double check my flters.  You have helped me so much!  If you are ever in San Diego let me kow! I owe you a drink!

[Taffalaffa]

@MFelix Thank you so much!  I feel like a total bonehead!  Serves me right from copying from a different visual.  I was going crazy trying to figure out the problem.  This is a good lesson learned to double check my flters.  You have helped me so much!  If you are ever in San Diego let me kow! I owe you a drink!