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.
Totals not calculating correctly using SumX
Hey there, love this community as it's been a huge help along my career path. I have a scenario where only these 2 totals are not calculating correctly, and I've used SumX in the past with success but it doesn't appear to be working this time. Please advise. Neither of these DAX metrics are calculating the total correctly: MemberNumberDISTINCTCOUNT = SUMX ( VALUES ( Heloc3MonthAdvances[TransactionDateMonth] ), DISTINCTCOUNT ( Heloc3MonthAdvances[MemberNumber] )) MemberNumberYTD DISTINCTCOUNT = SUMX ( VALUES ( Heloc3MonthAdvances[TransactionDate].[Month]), TOTALYTD( DISTINCTCOUNT('Heloc3MonthAdvances'[MemberNumber]),DateTable[Date]))
Total/Subtotal value sum of lines measure result
Hi, I'm trying to create a measure with a specific behaviour. Both cycles and time are a simple SUM, nothing else. Cycles (#/h) measure is define as seen below. Cycles (#/h) = DIVIDE([Cycles (#)],[Time (h)]) What I want a result is: - If I have more than one Line selected (as the image) the total or subtotal should be 144.17 + 83.46 = 227.63 - If I have only one Line selected the total or subtotal should be either 144.17 or 83.46, depending on which is selected. How can I achieve this? Thank you.How to display Grand Total correctly with USERELATIONSHIP?
Good day, I’m having trouble with getting the correct Grand Total for my pivot table. I have two tables. Fact table of email worked by an employee. It has a pkey column which is just a concatenation of week and agentId. Dimension table that has the login data of employee. It has an active citrixKey connected to Fact table.In general, Fact.agentId is the same as Dimension.citrixUsername, however an employee encountered issues with the citrixUsername and is now using Dimension.ntLogin. When I tried to build a pivot table with rows as agentId and values as sum of values, the grand total is not correct. Here are my measures: sumEmails:= SUM( 'Fact'[Value] ) calcEmails:= IF( [sumEmails] = BLANK(), CALCULATE( [sumEmails], USERELATIONSHIP('Fact'[pkey], 'Dimension'[ntloginKey]) ), [sumEmails] ) Sample
