Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Year - Month Name Slicer Not filtering 1 Table

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 ()
)
 

 

 

 

 

Need Help