Diffence Report

[aww91]

Greetings,

Any help with this problem will be greatly appreciated. Trying to create a difference report and I am running into problems with displaying two summaries (Net Increase and Decreases). The report is intended to allow the user to select beginning and end dates from the dropdowns and to display summary and detail information (see screen shot). The problem is that I cannot seem to get the right filter context needed to display Increase and Decrease – the net change is displaying fine. Again, thanks in advance for any suggestions.

Below: Screen shot of expected report, and link to Power BI application (Google Drive)

Difference Report.pbix

[Greg_Deckler]

If you are referring to your totals in your table, then see this article:

https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376

[aww91]

Good article, very well written however my situation is a little different. I am trying to sum separately positive and negative in the measure SumNetChg.

[aww91]

Any other ideas or suggestions? I have been working on this problem for a week. Thanks in advance.

[v-yuezhe-msft · Accepted solution]

@aww91,

Create the following measures in your Demand by Dates table.

checkpositive = IF([SumEndDate]>[SumBegDate],[SumEndDate]-[SumBegDate],0)

checknegative = IF([SumEndDate]<[SumBegDate],[SumEndDate]-[SumBegDate],0)

Increase = IF(COUNTROWS(VALUES('Demand By Dates'[PPM ID]))=1, [checkpositive],SUMX(VALUES('Demand By Dates'[PPM ID]),[checkpositive]))

Decrease = IF(COUNTROWS(VALUES('Demand By Dates'[PPM ID]))=1, [checknegative],SUMX(VALUES('Demand By Dates'[PPM ID]),[checknegative]))

Regards,
Lydia

[aww91]

Outstanding! Works perfectly. Thank You.