Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Reply
Anonymous
Not applicable

How to calculate Adjustments using columns and measures?

Hi!  I'm a new Power BI user and was unable to find the answer to my question elsewhere.  Hopefully I can explain this correctly.  I want to be able to calculate an adjustments amount using two measures and a column.  The column contains the following information (which is entered manually, on a monthly basis):

 

Total Revenue:

109000

265000

354000

511000

698000

null

null

null

null

null

null

null

 

That column is next to another column which separates those numbers by Month and year, for example:

 

Months:

July 2017

August 2017

September 2017

October 2017

November 2017

December 2017

January 2018

February 2018

March 2018

April 2018

May 2018

June 2018

 

Ultimately, my formula would be: Total Revenue (Column) - Total Online (Measure 1) - Total Offline (Measure 2) = Adjustments

 

However, I want Power BI to calculate this for each of the months so we can filter it using a Month slicer.  I'm not sure whether this is even possible or whether this can be done either through using a measure or a calculated column.  I tried both ways and was not able to get it to work.  Power BI requires me to put something in front of the column when using it with the measures (for example, sum(Total Revenue (Column) - Total Online (Measure 1) - Total Offline (Measure 2)).  By using Sum() it is not returning the result that I need for the individual months.

 

Extra info:  When used individually, the measures and the column work well with the month slicer.  The measures also work well when adding or subtracting from one another.  It is only when I try and include the column with the measures that things begin to calculate incorrectly.

2 REPLIES 2
v-ljerr-msft
Microsoft Employee
Microsoft Employee

Hi @Anonymous,

 

Could you post your real table structures(including the relationships and the measures you're using) with some sample/mock data, and the expected result? So that we can better assist on this issue. Smiley Happy

 

Regards

Anonymous
Not applicable

Or, is there a way to create a measure that is not affected by the month slicer and only calculates based on YTD or sum()?  Basically a measure that returns a "locked" value.  If the measure is not affected by the month slicer then I still WOULD want the column to be affected by the month slicer.  I hope that made sense 😕

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.