Need to include Filter inside CalculateTable

[harirao]

Hi All,
I am working on a dax , required to add one filter inside the below dax(highlited in green)

Visibility = MEDIANX(

SUMMARIZE(Query1,Query1[Actual _Wk_Cond2],Query1[subregion],Query1[actual_visibility_Weeks],Query1[OpportunityId],"Viswks",

COUNT(Query1[OpportunityId])),

[actual_visibility_Weeks])

Filter to be added i.e Query1[Actual _Wk_Cond2]="Yes"

Please help me on above.
Thank you.

Regards,
Hari

[tex628 · Accepted solution]

Try this:

Visibility = 
MEDIANX(
SUMMARIZE(
	Filter(Query1,Query1[Actual _Wk_Cond2] = "Yes"),
	Query1[Actual _Wk_Cond2],
	Query1[subregion],
	Query1[actual_visibility_Weeks],
	Query1[OpportunityId],
	"Viswks",
	COUNT(Query1[OpportunityId])
),
[actual_visibility_Weeks])

[amitchandak · Accepted solution]

@harirao , try like

Visibility = MEDIANX(
SUMMARIZE(filter(Query1[Actual _Wk_Cond2]="Yes"
),Query1[Actual _Wk_Cond2],Query1[subregion],Query1[actual_visibility_Weeks],Query1[OpportunityId],"Viswks",
COUNT(Query1[OpportunityId])),
[actual_visibility_Weeks])

[amitchandak · Accepted solution]

@harirao , try like

Visibility = MEDIANX(
SUMMARIZE(filter(Query1[Actual _Wk_Cond2]="Yes"
),Query1[Actual _Wk_Cond2],Query1[subregion],Query1[actual_visibility_Weeks],Query1[OpportunityId],"Viswks",
COUNT(Query1[OpportunityId])),
[actual_visibility_Weeks])

[harirao]

 Hi @amitchandak 

Thanks for your response, getting error.

Regards,

Hari

[amitchandak · Accepted solution]

Visibility = MEDIANX(
SUMMARIZE(filter(Query1,Query1[Actual _Wk_Cond2]="Yes"
),Query1[Actual _Wk_Cond2],Query1[subregion],Query1[actual_visibility_Weeks],Query1[OpportunityId],"Viswks",
COUNT(Query1[OpportunityId])),
[actual_visibility_Weeks])

Query1 in the filter is missing. My mistake

[tex628 · Accepted solution]

Try this:

Visibility = 
MEDIANX(
SUMMARIZE(
	Filter(Query1,Query1[Actual _Wk_Cond2] = "Yes"),
	Query1[Actual _Wk_Cond2],
	Query1[subregion],
	Query1[actual_visibility_Weeks],
	Query1[OpportunityId],
	"Viswks",
	COUNT(Query1[OpportunityId])
),
[actual_visibility_Weeks])