Date Slicer and SELECTEDVALUE DAX in card visual not working as intended

[Anonymous]

I have an issue with Date Slicer not working with SELECTEDVALUE in a card visual.
I created a date table (DateTable) with DAX 

DateTable = 
VAR _calendar = CALENDAR("1/4/2022", "31/3/2030")
RETURN
    ADDCOLUMNS(
        _calendar,
        "Year", YEAR ([Date]),
        "MonthNo", MONTH([Date]),
        "Month", FORMAT([Date], "mmmm"),
        "MonthYearNo", FORMAT([Date], "yyyymm"),
        "Month Year", FORMAT([Date], "mmm-yyyy")
        
    )

Also, I created a calculated column in the DateTable called Period_MonthYear and the values are P1 Apr-22, P2 May-22 ... P12 Mar-24.
I have a company table which has Company, Location and FactTable called OPMetrics.
The DateTable is related to OPMetric with Date, the company Table is link to OPMetrics with Company.
Now, for visualization, I created a slicer from DateTable using Period_MonthYear and another slicer from company table [company]

I wrote DAX 

Selected Period = SELECTEDVALUE( DateTable[Period_MonthYear])

I put it in the card visual but when i selected a slicer from the datetable and company the card visual returns blank but when i select all company in the slicer and any value from Period_monthYear slicer it works fine.

The issue is the company slicer when any value is selected with date slicer the card visual return blank.
please how can i fix this? 

[johnt75]

Are the relationships single direction or bi-direction ? It sounds like they should both be single, so that Date filters OPMetric and Company filters OPMetric but OPMetric doesn't filter anything.

[Anonymous]

@johnt75  They are single relationships. OPMetric is the fact table while Company and Datetable are Dimensions

[johnt75]

Use Performance Analyzer to copy the DAX query used for the card visual, both when it is working and when it is not. Paste both copies into DAX Studio and see what the differences are. That should help you identify what is going wrong.

[Anonymous]

@johnt75  - The performance Analyzer below
Not Working

// DAX Query  
DEFINE
	VAR __DS0FilterTable = 
		TREATAS({"Company A"}, 'Company'[Company])

	VAR __DS0FilterTable2 = 
		TREATAS({"P1 Apr-23"}, 'DateTable'[Period_MonthYear])

	VAR __DS0FilterTable3 = 
		TREATAS({"FY 2023/24"}, 'DateTable'[FY])

EVALUATE
	SUMMARIZECOLUMNS(
		__DS0FilterTable,
		__DS0FilterTable2,
		__DS0FilterTable3,
		"Selected_Period", IGNORE('DateTable'[Selected Period])
	)

Working when company is not selected

// DAX Query
DEFINE
	VAR __DS0FilterTable = 
		TREATAS({"P1 Apr-23"}, 'DateTable'[Period_MonthYear])

	VAR __DS0FilterTable2 = 
		TREATAS({"FY 2023/24"}, 'DateTable'[FY])

EVALUATE
	SUMMARIZECOLUMNS(
		__DS0FilterTable,
		__DS0FilterTable2,
		"Selected_Period", IGNORE('DateTable'[Selected Period])
	)

I don't know what to do

[johnt75]

Can you share a PBIX with any confidential info stripped out ?