Year - Month Name Slicer Not filtering 1 Table

[Anonymous]

Hi guys,

I just brought in a crm_customers table to my report and joined it to 3 tables: users, date dimension, space mapping. The only table that does not seem to have joined properly is the date dimension. 

crm_customers.date -> date dimension.date.

For some reason, my month_year_name slicer is not filtering the data. The month_year_name column (categorized as a text) is sorted by [year & month number] (categorized as a whole number). For example: 2019-February provides me with 0 results. However, when unselected, I see the sum value. My custom time intelligence functions do not work. Hopefully someone can help, thanks in advance.

Measures: 

TDY: 

TDY Signup = CALCULATE([Nbr SignUps Retail], 'Date Dimension'[Date] = TODAY() -1) + 0

MTD; 

MTD Signups =

IF (

HASONEVALUE ( 'Date Dimension'[Year] )

&& HASONEVALUE ('Date Dimension'[Month No] ),

CALCULATE (

[Nbr SignUps Retail],

FILTER (

ALL ( 'Date Dimension' ),

'Date Dimension'[Year] = VALUES ( 'Date Dimension'[Year] )

&& 'Date Dimension'[Month No] = VALUES ( 'Date Dimension'[Month No] )

&& 'Date Dimension'[Date] < TODAY()

)

),

BLANK ()

) + 0

YTD:

YTD Signups =

IF (

HASONEVALUE ( 'Date Dimension'[Year] ),

CALCULATE (

[Nbr SignUps Retail],

FILTER (

ALL( 'Date Dimension'),

'Date Dimension'[Year] = VALUES ( 'Date Dimension'[Year] )

&& 'Date Dimension'[Date] < TODAY()

)

),

BLANK ()

)

[v-yulgu-msft · Accepted solution]

Hi @Anonymous ,

Please provide some dummy data and show desired result with examples.

How to Get Your Question Answered Quickly

Regards,

Yuliana Gu