Forum Discussion

pankajsk83's avatar
pankajsk83
Regular Visitor
2 years ago

All doesn't override filter CONTEXT

Hi All,

 

In the image here, I am trying to get All to override filter context on category. However, that doesn't happen. It works for every other column like Brand, color or manufacturer. However, it doesn't remove filter context for category and subcategory. I even tried using the category field which is within the hierarchy but no success.

all
Filter

1 Reply

  • OwenAuger's avatar
    OwenAuger
    Super User
    2 years ago

    Hi pankajsk83 

    The logic of your [all trial] measure looks correct, assuming that your visual is grouping by 'Product'[Category] only.

     

    Is there by any chance a sort-by column or group-by defined on 'Product'[Category]?

     

    If you examine the DAX query generated by the visual using Performance Analyzer, it may help answer this.

     

    In the SUMMARIZECOLUMNS portion of the query, if there are two columns inside ROLLUPGROUP, then that is the source of the problem, and the second column would need to be added to ALL.

     

    SUMMARIZECOLUMNS(
	ROLLUPADDISSUBTOTAL(
		ROLLUPGROUP('Product'[Category], 'Product'[Some Other Column]), "IsGrandTotalRowTotal"
	),
	"all_trial", 'Sales'[all trial],
	"v_all_trial_FormatString", IGNORE('Sales'[_all trial FormatString])
)

     

     

    Otherwise, this is how I would expect the SUMMARIZECOLUMNS portion of the query to appear if no sort-by or group-by columns are defined:

     

    SUMMARIZECOLUMNS(
	ROLLUPADDISSUBTOTAL('Product'[Category], "IsGrandTotalRowTotal"),
	"all_trial", 'Sales'[all trial],
	"v_all_trial_FormatString", IGNORE('Sales'[_all trial FormatString])
)

     

     

    If the above doesn't help, could you post a link to a PBIX demonstrating the issue?

     

    Regards