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,...
all
Filter
OwenAuger's avatar
OwenAuger
Icon for Super User rankSuper 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