Forum Discussion

harirao's avatar
harirao
Post Prodigy
6 years ago
Solved

Need to include Filter inside CalculateTable

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
Need Help
Show and Tell
Tips and Tricks
  • tex628's avatar
    tex628
    6 years ago

    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's avatar
    amitchandak
    6 years ago

    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's avatar
    amitchandak
    6 years ago

    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

4 Replies

  • tex628's avatar
    tex628
    Community Champion
    6 years ago

    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's avatar
    amitchandak
    Super User
    6 years ago

    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's avatar
        amitchandak
        Super User
        6 years ago

        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