Excluding Null Dates from a Dimension not used in the chart

[#1]

Hi, I have a chart that neither the dimension nor the expression uses the Date. But the date has some blank values, and return values. So, for example, if I want a expression "sum([Sales])", and select a blank date, I get values. I want to use some sort of set analisys to exclude this date blank values, but I didn't find what went wrong. Can someone answer this for me, please?

[Gysbert_Wassenaar · Accepted solution]

If you can select a blank date, then it does have a value. Nulls cannot be selected. So try something like sum({<MyDate-={''}>}Sales) or perhaps sum({<MyDate={'?*'}>}Sales)

[er_mohit]

firstly check on supress when value is null for Date in dimension tab

or you can try this also

add calculated dimension

aggr(only({<Date-={' ','-'}>}Date),Date)

[#4]

Thank you, the second one worked pretty well, can you explain for me what the '?*' means?

[Gysbert_Wassenaar]

?* matches any value that is at least 1 character long.