Forum Discussion

DAX_merchant's avatar
DAX_merchant
Icon for Helper II rankHelper II
2 years ago

Removing filter context in a visual

Dear Forum,    Since my last post, I have learned much about filter and row context, iterators etc... This has really opened my eyes to the capabilities of DAX, and allowed me to answer many of the...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi DAX_merchant ,

Thanks for reaching out to us with your problem. Base on your description, it seems that you want to get the count of location id which not effect by the filter or slicer. In order to get a better understanding on your problem and make the further troubleshooting, could you please provide the following info? It would be helpful to find the solution.

  • Which fields be applied on the slicers? Are they from different tables?
  • Is there any relationship created between the table 'location' and other table?
  • Could you please provide some sample data(exclude sensitive data) and expected result with the special examples and screenshots base on provided sample data?

 It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

How to upload PBI in Community

Best Regards

DAX_merchant's avatar
DAX_merchant
Icon for Helper II rankHelper II
2 years ago

Thank you for the response Anonymous . I have actually found out what is being filtered out, and it has to do with a report level filter. To answer the questions you asked as well: No fields from different tables, and no relationships as I created a copy of the table and the issue persisted.

 

My question now is: I have a report level filter with 5 categories, only 2 of which should be shown. There is no slicer on the page with that particular column. 

 

When I do the count of distinct locations, I use all(location[id]) as described above, so it should remove all filters on location ID but not on anything else. This is reflected in the count as for example, I have a slicer for region, which when selected will count only those in that region, but another slicer for store type, which if left unselected will still show all stores in that region. Now, the report level filter, for those two categories out of the 5, is overriden with the category that the selected store ID belongs to. So if the ID selected is category A, then the count will only include category A stores.

Why does this only affect the report level filter?