Not show Sum or Average in Total (PIC INCLUDED)
I have a matrix table with two rows. Main one is C1, and the second is C2. I then have C3 for values. I want to display the sum only by C2 as in this situation it doesnt make sense to show C1 totals. Is there a way to omit the numbers in the main category of C1? I have displayed a pic. Any help would be appreciated. So omit the 15 under AAA, BBB, etc. Just clicking row totals doesnt work because I cannot have the end-user click the plus sign and have it roll up to that AAA = 15 ever.
SUMX is not showing calculating any totals
I have the following measure: 1. Project Load = var result = CALCULATE(SUMX(SUMMARIZE(Project,Project[Project Number]),SUM(Project[Project Value])),ALL('Month Table with weeks')) return result 2. monthly_project_value = CALCULATE( sumx( FILTER('Month Table with weeks', DATE(YEAR(CALCULATE(MIN(Project[Project Start]), ALL('Month Table with weeks'))), MONTH(CALCULATE(MIN(Project[Project Start]), ALL('Month Table with weeks'))), 1) <= MIN('Month Table with weeks'[First day of Month]) && DATE(YEAR(CALCULATE(MIN(Project[Project End]), ALL('Month Table with weeks'))), MONTH(CALCULATE(MIN(Project[Project End]), ALL('Month Table with weeks'))), 1) >= MAX('Month Table with weeks'[First day of Month] ) ), [Project Load] ) ) The filter is used to get the project value for a selected month if the project is live during that month else to not show anything. Although the individual rows are coming correctly but the total is not getting calculated and shows empty.Total not visible in Table
Hi everyone, I have a issue, where values are shown on row level but not at the total level. Logic for the calculation has to be as followed: 1. We have to check Billings for the previous month when the Net Billings was not 0, then I have to sum Cost after that period when Net Billings is not 0. 2. If there no record where the Net Billings is not 0 then sum all the Cost. Cost = CALCULATE( SUM('Project Actuals'[Internal_Costs]), USERELATIONSHIP('Project Actuals'[Date],'Rev Rec'[Date]))<p> </p><p> </p><p> </p><p> <li-code lang="markup">Billings = SUM('Rev Rec'[Net Billings]) Below is the DAX which I have tried, but it's not giving me total. Final Cost = VAR _currentmonth = SELECTEDVALUE('Rev Rec'[Date]) VAR _lastNonZeroDate = CALCULATE( LASTDATE('Rev Rec'[Date]), FILTER( ALL('Rev Rec'[Date]), 'Rev Rec'[Date] < _currentmonth && [Net Billings] <> 0 ) ) VAR _earliestDate = CALCULATE( MIN('Rev Rec'[Date]), FILTER( ALL('Rev Rec'[Date]), [Net Billings] = 0 ) ) RETURN IF( ISBLANK(_lastNonZeroDate), CALCULATE( [Internal Cost], 'Rev Rec'[Date] >= _earliestDate && 'Rev Rec'[Date] < _currentmonth), IF( _lastNonZeroDate <> BLANK(), CALCULATE( [Internal Cost], FILTER(ALL('Rev Rec'[Date]), 'Rev Rec'[Date] > _lastNonZeroDate && 'Rev Rec'[Date] < _currentmonth))Below image shows, the first scenario when we have a Value in Net Billings, so in this case I need sum after that period. Second Scenario, when there is no values for previous months in Net Billings, then we have to sum everything in Cost. I would appreciate your help, and if there are any better solution for this. Thanks, Nik
