I have two data tables that are linked by a name field. My 'fact' table has high level information by name, the dim table has detailed address data for suppliers, in many instances multiple addresses per supplier. I have created a DAX measure that counts the rows of the dim table and was hoping that when I applied page level filters to my visuals the DAX result would update based on those filters, but it isn't, I'm assuming because one of the filters I'm applying to the page is applicable to the table not referenced in the DAX measure (which makes sense, but I want to correct for). I can't share the data itself, but here's the pertinent info.
dim table = 'Supplier Summary' and it has a summary of total costs, 'Supplier Summary[Total Cost]'
fact table = 'Supplier Addresses'
the measure i created is just: COUNTROWS['Supplier Addresses'], and it works fine by itself, but if I apply a page level filter where 'Supplier Summary[Total Cost]' > 5000 then the count of rows/addresses in the 'Supplier Addresses' table doesn't update correctly to match the total number of rows showing in a table visual on that page. I'm wondering how I can update the DAX to dynamically incorporate the page level filter (i.e. not set a second filter that just uses the 5000 threshold in my example, but would dynamically update if I changed the filter for that page to 15,000 or 20,000). Is that possible? Thanks in advance.
