Knowledge Drop

Why are my explore filters not getting added when I drill down on a measure?


Userlevel 4

Last tested: Sep 15, 2019
 

It is most likely because the measure may have filter defined, i.e it is a filtered measure. When you have a filtered measure AND you also have filters on the front end for the same measure, when we drill on this measure, it takes only the filtered measure and does not combine both the filters.

Another reason could be because the filter is on a measure, which results in a HAVING clause. That HAVING clause only makes sense for the original query, so the drill query won't include the measure filter.

 

This content is subject to limited support.                

 

 


0 replies

Be the first to reply!

Reply