Dynamic Filtering of derived DAX table based on the filters applied to the mainTable /source table

[ksubramaniyam41]

Hi All 

I have the source Table with columns

i have created for Derived table for simmarize the data 

and I have created the one more derived table sum of distinctcount of Usage DT 

Usage Days = SUMMARIZE('TOP Users By Day','TOP Users By Day'[CUSTOMER_ACCOUNT_NM],'TOP Users By Day'[Agreement_DateRange], 'TOP Users By Day'[USER_LOGIN_ID], "Usage_Days", COUNT('TOP Users By Day'[Usage Days]))

i have created one Matrix table visual and i have got the usages days by using the distinctcount Usage DT  now i want filter by using the slicer same usages days

Now i want to filter the Usages Days using Slicer with all the Visuals in the same page but the filter is not working even if we use any date reange in the dashboard data is not filtering. 

Kindly some one Please help me to resolove the issue.

[v-tangjie-msft]

Hi @ksubramaniyam41 ,

In order to better understand your demands and give the right solution, could you please provide some more specific information? Such as your desensitized example data and a screenshot of your desired results?

Thanks for your efforts & time in advance.

Best Regards,

Neeko Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

[ksubramaniyam41]

Hi Tangjie,

i want the filter the data from silire for usage days what ever results is displayed in the matrix Visual table same will display in the Usage Days slicer but when you filter/ select any days from slicer(usage Days) it is not filter and more over when you select data range from slicer that also not filter the data in the slicer(Usage Days) not chnage based on the date range.