Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Incorrect Measure Total

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.

Need Help

4 Replies

  • AlB's avatar
    AlB
    Community Champion
    7 years ago

    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's avatar
      Anonymous
      Not applicable
      7 years ago

      Сумма до установки , АЗН - 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's avatar
        v-chuncz-msft
        Community Support
        7 years ago

        Anonymous,

         

        You may check if it is caused by date hierarchy.