Grouping Based on Date Filter then Count

[Anonymous]

Hello,

I have a scenario that i want to apply.

According to the screenshot attached, i have made group on the first 3 columns and get the count of rows.

I want to make grouping on them also based on filter/slicer on visual it "after transformation".

Please, Any help ? 

[Anonymous]

Hi @Anonymous,

The filter and slicer that used on the data view not able to interact with backend query tables.
BTW, these filter/slicers also not able to affect the data model tables to create dynamic calculated column/tables because they are work on different data levels.

Notice: the data level of power bi.
Database(external) -> query table(query, custom function, query parameters) -> data model table(table, calculate column/table) -> data view with virtual tables(measure, visual, filter, slicer)
Regards,

Xiaoxin Sheng