Measures not calculating when I use date slicer

[lisaeugene]

I have a transaction table which is the many side of a one-to-many relationship with a dates table. I created a measure called Distinct Order Count in the Transaction table:

Distinct Order Count = DISTINCTCOUNT('Txns'[Order Num])

It calculates correctly as a single aggregate number, but I need to slice it by year and month to see trends. 

So I added 2 slicers - One using the column Year from my Dates table and another using column Month Name. I thought this was okay because I have a one-to-many relationship between Dates and Transactions. But every time I add these slicers, the calculation for 'Distinct Order Count' measure turns to Blank. 

Any ideas on why this happens and how I can fix it? 

[v-jiascu-msft]

Hi @lisaeugene,

Could you mark the proper answer as a solution, please?

Best Regards,

Dale

[v-jiascu-msft]

Hi @lisaeugene,

One possibility is the relationship is invalid. For instance, one side is Date while the other side is DateTime. Though we can establish a relationship. But it won't work. You can drag the two date columns together to check out. 

If this can't solve your issue, please provide a sample of your data.

Best Regards,

Dale

[Anonymous]

Logically it should work, Can you post some sample date please?