Filter Problem

[idundar]

Hi,
I'm working on a period-end stock calculation. When calculating the period stocks, I take the production date and sales date of the products as basis. I have created a measure named DSS for the account of period-end stocks.
DSS measure;

DSS =
CALCULATE(COUNTROWS(Liste);
FILTER(VALUES(Liste[prod]);Liste[prod]<=MAX(dimdate[date]));
FILTER(VALUES(Liste[sales]);OR(Liste[sales]>MIN(dimdate[date]);ISBLANK(Liste[sales])))

Sales measure:
sales = CALCULATE(COUNTROWS(liste);FILTER(VALUES(Liste[sales]);Liste[sales]<=MAX(dimdate[date]));FILTER(VALUES(Liste[sales]);Liste[sales]>=MIN(dimdate[date]));USERELATIONSHIP(Liste[sales];dimdate[date]))

Production Measure:

Prod=
CALCULATE(COUNTROWS(liste);FILTER(VALUES(Liste[prod]);Liste[prod]<=MAX(dimdate[
date]));FILTER(VALUES(Liste[prod]);Liste[prod]>=MIN(dimdate[date])))

Relations between the dimdate table and the fact table inactive to calculate multi dates column.

The measurement created for the period end stock calculation is calculating correctly.

My problem is that when I click the data in the table that contains the periodic sales, production and end-of-stock information that I calculated with measurements, it does not filter the data in the other table on the same report page.

[Ashish_Mathur]

Hi,

Share some data and show the expected result.

[idundar]

Hi,

when any value of the table is clicked, the other table does not filter that data. When you change the connection between Dimdate and fact table, there is an error in calculating the table values.

[Ashish_Mathur]

Hi,

Thank you for sharing that information but I do not think I will be able to help you.  Someone else will help you.

[idundar]

Measures that make up the table

DSS =

CALCULATE(COUNTROWS(Liste);

FILTER(VALUES(Liste[prod_date3]);Liste[prod_date3]<=MAX(dimdate[tarih]));

FILTER(VALUES(Liste[sales_date]);OR(Liste[sales_date]>MIN(dimdate[tarih]);ISBLANK(Liste[sales_date]))))

production = CALCULATE(COUNTROWS(liste);FILTER(VALUES(Liste[prod_date2]);Liste[prod_date2]<=MAX(dimdate[tarih]));FILTER(VALUES(Liste[prod_date2]);Liste[prod_date2]>=MIN(dimdate[tarih])))

Sales = CALCULATE(COUNTROWS(liste);FILTER(VALUES(Liste[sales_date]);Liste[sales_date]<=MAX(dimdate[tarih]));FILTER(VALUES(Liste[sales_date]);Liste[sales_date]>=MIN(dimdate[tarih]));USERELATIONSHIP(Liste[sales_date];dimdate[tarih]))

relations between liste[prod_date2] & dimdate[tarih] - liste[prod_date3] & dimdate[tarih] - liste[sales] & dimdate[tarih] are inactive