Filtering Summarized table from main table using daterange from the orignal table

[mohitbhagat92]

I have an order table with sales of products from different dates (table A). I have created a summarized table, grouped on location and product. Now I want that if I use a date range slicer from table A, I want the summarized values from table B to change.

I tried passing SelectedValue, but it is not authorized.

How can I achieve this?

Alternatively, is there any other way through which I can create summarized temporary table somewhere on changing date range, because I need to count the number of rows from this summarized table. 

[v-qiuyu-msft]

Hi @mohitbhagat92,

The slicer visual can't be used to filter summarized table column values. In your scenario, you could create a measure to return count values. Please share some sample data of these two tables so we can try to share corresponding DAX. 

Best Regards,
Qiuyun Yu