Writing a measure to subtract two columns same table with filters
Hi I have 2 columns that i would like to subtract from one another after applied filters. Eg. Column B (with version type x and month number x) - Column A (with version type x and month number x) What I currently have and is giving me wrong answer: ForecastCMVariance = CALCULATE(SUM(FilteredCommercial[Forecast]) - CALCULATE(SUM(FilteredCommercial[Capital Rental]))) How do I go about writing this dax? DAX filter
Subtracting two measures not working
Hi Community, I am having an issue with what should be a simple thing to do, calculating the difference between measures. Below is the table: The "Account" field in rows is a calculated item from Calculation Group 1 and the "Time Calculation" is a calculated item from Calculation Group 2. As you can see, the difference between the whole number values is calculating correctly but the difference between the decimal numbers and percentages is not calculating correctly. (Highlighted in yellow) The three variances are calculated as follows: vs QBR = [Act] - [QBR] vs AOP = [Act] - [AOP] vs LY = [Act] - LY] The decimal numbers are taking "Account" divided "Volume". For example, Net Sales in Calculation Group 1 (row 10 in the matrix) Net Sales = VAR NS = CALCULATE ( SELECTEDMEASURE (), 'ACT/QBR/AOP'[Line Item] = "Net Sales" ) VAR Volume = CALCULATE ( SELECTEDMEASURE (), 'ACT/QBR/AOP'[Line Item] = "Volume" ) RETURN DIVIDE ( NS, Volume, 0 ) All other decimal numbers are calculated the same way except for the first variable. I am not sure what the issue is but hoping someone can assist with what should be an easy thing to do. Thank you!
Subtraction is not working for me
I will like to get the difference between two measure' values #AADP MAU Increase = [#AADP MAU_End] - [#AADP MAU_Start] Individually, these show as: #AADP MAU_Start = 166M #AADP MAU_End = 170M But when I do the substraction, I am getting 0 or 0.00 I have tried different things, such as the below, but still get 0 #AADP MAU Increase = FORMAT([#AADP MAU_End] - [#AADP MAU_Start], "General Number")Filter on first column, then subtract the filtered values
My first column contains is "Yes/No" containing "Yes/No" values. My second column is Dollars (this is a measure.) I would like to create a measure that represents: Yes Dollars - No Dollars But I'm getting kludgey and chasing my tail with my filter then subtract. Any boost on how to achieve this elegantly? Much thanks!
