User Profile
rico343
Frequent Visitor
Joined 1 year ago
User Widgets
Contributions
Re: why is my measure calculation not happy when I add it to my table visual
I tried that as well. The data is there and the calculation is correct, the issue is that when I use subtraction or addition in the formula it adds additional date rows to the displayed table. In my first image the dates are my calculated 'start of week' field. This works great until I put in a measure with the subtraction or addition in the formula. I'm not sure why it does that. It does not add the additional dates when I change the formula to multiplication or addition. I was able to work around this by filtering out the data fields that are blank for the additional date rows.Re: why is my measure calculation not happy when I add it to my table visual
It appears to have to do with the '-' subtraction. if this is changed to * or / it displays properly. How do I make the formula work properly? RequiredAdjustment40 = SUM(Hours[Calculated_Remaining])-(Headcount[Headcount Value])*('Monday 40'[Monday 40 Value]) This also results in the same issue when just using a supplied number. RequiredAdjustment40 = SUM(Hours[Calculated_Remaining])-50 And why do these work? RequiredAdjustment40 = SUM(Hours[Calculated_Remaining])/50 RequiredAdjustment40 = SUM(Hours[Calculated_Remaining])*50 UGH! I feel like this should be easy.Re: why is my measure calculation not happy when I add it to my table visual
Sure the difference is that those two values are parameter values that are supplied on the page by the user, and they can change as needed to adjust the data in the report. They are not apart of the original table that was imported, so there is no relationship to make. I just need to use these values to recalculate the original data and have it display in my table.why is my measure calculation not happy when I add it to my table visual
I have a requirement to calculate a data column based on a couple parameter values. When I do this and add the measure to my data table it does not display properly with the rest of the data. Here is the measure formula: RequiredAdjustment40 = SUM(Hours[Calculated_Remaining])-(Headcount[Headcount Value])*('Monday 40'[Monday 40 Value]) Calculated_Remaining is the first data column shown in the table. As you can see below. My calculation is correct as shown on the right when the week is selected from the data table. However, when I add the measure to the table as a new column it adds a day row and the calculation is not correct. What is wrong?
