Incorrect Measure Total

[Anonymous]

Hi, I have problem in measure total . Power Bi summarizes the data which is not in one month. The amount does not change by month. What could be the problem? 5 days can not solve this problem. 

Сумма до установки , АЗН = IF(ad_sales_info[Сумма мера] <>BLANK();ad_sales_info[ВычСумма до установки])

ВычСумма до установки = CALCULATE(SUMX(ad_sales_info;ad_sales_info[Сумма]);DATESBETWEEN(ad_sales_info[Дата].[Date];MAX(ad_sales_info[Первый месяц]);MAX(ad_sales_info[EndMonth]));ALLEXCEPT(ad_sales_info;ad_sales_info[Товар Наименование]))

Сумма мера = CALCULATE(SUM(ad_sales_info[Сумма]);FILTER(ad_sales_info;ad_sales_info[Столбец]<1);FILTER(ad_sales_info;ad_sales_info[Дата].[Date]>STARTOFMONTH((ad_sales_info[EndMonth].[Date]))))

Thank you all for your attention.

[AlB]

Hi @Anonymous

Can you explain a bit more what the problem is? It's not clear enough. Maybe through an example based on your sample data indicating what result you get now and what the correct result would be and why.

Showing a sample of your data model would also help or, if possible, the pbix

[Anonymous]

Сумма до установки , АЗН - is constant . The problem is in these values. The problem is that for example, if I choose the sale of storefronts in a few months and I choose the sale, then the sum of all the months appears. But it should display the amount by months. Now on the screen the amount before installation, AZN - shows the value of December in all months. In connection, I do not think that there is a problem.

[v-chuncz-msft]

@Anonymous,

You may check if it is caused by date hierarchy.

[Anonymous]

I think the problem is created because of time, but I don’t know how else to do it. This value should be for all months of the same. But it should show only from the month of installation. And now in all months shows