Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

DAX

I have a Production table, DimDate table. I needed to display weekly sum which I was able to do using SUMMARIZE function. Output of SUMMARIZE function is in 'TableS' with 2 columns WeekNo, SumP.  Now...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Yes correct. You got it what I am trying to do.

parry2k's avatar
parry2k
Super User
7 years ago

Anonymous  add following as a measure

 

SumP = 
SUMX( 'DimDate', 
	IF( 'DimDate'[Day] = 7, 
		CALCULATE( 
			SUM( Table1[Production] ) , 
			ALLEXCEPT( 'DimDate', 'DimDate'[WeekNo] ) 
		)  
	) 
)