Dynamic Filtering of derived DAX table based on the filters applied to the main/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 

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.

[ksubramaniyam41]

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.

[v-zhangti]

Hi, @ksubramaniyam41 

Can you provide sample data for testing? Sensitive information can be removed in advance. What kind of expected results do you expect? You can also show it with pictures. I look forward to your response.

Best Regards,

Community Support Team _Charlotte

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