SSAS Tabular - Date dimension not slicing fact table

[Anonymous]

Hi,

Not sure if this belongs here but I hope someone here can help me.
I have a functioning dim_date connected to my fact table which works just fine when I browse the cube ( dim_date.date_key = fact_table.date1 ).
I created another Date dimension like so: dim_date2.date_key = fact_table.date2

Somehow, the new dimension doesn't slice the fact table, and whenever I try to browse some measures from the fact table sliced by the new dim_date I get a blank value.

Any help would be appreciated.

[Icey]

Hi @Anonymous ,

Have you created relationship between the new dimension and the fact table?

Best regards

Icey

If this post helps, then consider Accepting it as the solution to help other members find it faster.

[amitchandak]

@Anonymous , Hope at that time the first date table is not filtering some other duration.

Means if first date filter oct and second one try to dispplay nov , then it will be blank.

[Anonymous]

Hi @amitchandak 
I missclicked the 'Solved' button by a mistake, sorry.
Of course the dates aren't being filtered at the same time.
Even in SSMS, when I browse the cube and drag the new date dimension with a simple count measure - I get a single blank value. 

[Jimmy801]

Hello @Anonymous

I moved the post from Power Query to Desktop

BR

Jimmy