Always show blank in dates

[Analitika]

I need always show blanks values by date,

now it show blanks only when whole period in slicer is selected

but if i move slicer, blanks is gone

I have a date slicer which refer to Date[Date],

relations on 'Table'[Date] = Date[Date]

also i have measure 
193 =
CALCULATE (
SUM ( 'Table'[Sum] ),
FILTER (
'Table',
'Table'[State] IN { "on", "edit" }
)
)

[amitchandak]

@Analitika , why date is blank, because not all dates are there in date table or it is blank in table ?

Try like

193 =
CALCULATE (
SUM ( 'Table'[Sum] ),
FILTER (
'Table',
'Table'[State] IN { "on", "edit" } || isblank('Table'[Date] )
)
)

[Analitika]

Dates is blanks in a Table, so your example is not work.

😕

[Analitika · Accepted solution]

Solved:

1. Create new Table with:

Blank
1
2
3
4
5
6
7
8
9
10
11
12

2. make relation on Date[Month]

3. Make additional measure for blanks

194 =
CALCULATE (
SUM ( 'Table'[Sum] ),
FILTER (
ALL('Table'),
'Table'[State] IN { "on", "edit" } &&
ISBLANK('Table'[date])
)
)

4. final measure

193 =
CALCULATE (
SUM ( 'Table'[Sum] ),
FILTER (
'Table',
'Table'[State] IN { "on", "edit" } &&
'Table'[date]<> BLANK()
)
)
+ [194]

[harshnathani]

Hi @Analitika ,

You probably need a dynamic end date to your Calendar Table.

Have a look at this video.

https://www.youtube.com/watch?v=qdhsq23cQhg

Regards,

Harsh Nathani

Appreciate with a Kudos!! (Click the Thumbs Up Button)

Did I answer your question? Mark my post as a solution!