average + filter which bases on date

[Anonymous]

Hello, everyone.

I'm a newcomer in PowerBI.

And i have a first unsolution trouble with PowerBI.

I have a some trouble with calculation average + filter with date.

I have a table A, which contains some info.

I have another table, which has calculation info from table A, and that table gets distinct info from columns table A

I'm using this DAG for creation table

DAX:

v_average_article_hist = DISTINCT(SELECTCOLUMNS(v_uniq_article_hist,"dep",v_uniq_article_hist[department],"subdep", v_uniq_article_hist[subdepartment]))

Than that table calculates other it's columns:

DAX:

1 = AVERAGEX(FILTER(v_uniq_article_hist,

v_uniq_article_hist[start_date] >= MIN(Dates[Date]) &&

v_uniq_article_hist[start_date] <= MAX(Dates[Date]) &&

v_uniq_article_hist[department] = v_average_article_hist[dep] &&

v_uniq_article_hist[subdepartment] = v_average_article_hist[subdep] &&

v_uniq_article_hist[step] = 1 &&

v_uniq_article_hist[works_days] < 1), v_uniq_article_hist[works_days])

...

And info in reports doesn't support changing date with slicer, but v_uniq_article_hist supports filtering with date.

But if i set the MIN(Dates[Date]) and MAX(Dates[Date]) ("01.01.2020", "01.12.2020"), it will be able to show info, which bases on date.

I don't know how to fix that trouble.

Please, help dear members from forum)

[AntrikshSharma]

@Anonymous  Attach your PBI file with the current problem and the solution that you are expecting.

[Anonymous]

Hello, @AntrikshSharma 

If slicser was changed, then table wirh red circle need to recalclulate

But it doesn't work. I have a communication in 

And DAtes[date]'s slicer impacts to 

But i don't know, how to change dax or schema of communication.

my pbix

https://drive.google.com/file/d/1ECB3jc83RYlB3uonNNNkKnJOKH0Kc89k/view?usp=sharing

[AntrikshSharma]

@Anonymous Not possible, the filters from slicers can't filter the Physical tables in a model.