Prevent Summarization in Table with Measures and Columns

[Anonymous]

Hi all,

I am looking for help with the following issue:

I have two measures that calculate a opening and closing balance based on a min and max date selected. Works all perfectly fine. The requirements for my task are asking me to give the end user the ability to select more than one month at a time. Unfortunately, when I do so, I see everything summarize. Ideally, I would like to have all columns summarize, BUT the Opening and Closing Calc Columns (see below). 

ProductBK	OpeningBalanceCalc	ClassSwitch	DepositLoanSwitch	GroupSwitch	InstrumentSwitch	LineSwitch	ProductSwitch	SmallChanges	NewLost	ClosingBalanceCalc
11	180003000	0	0	0	0	0	0	0	0	180003000
12	13999730	0	0	0	0	0	0	0	0	13999730
13	5994000	0	0	0	0	0	0	0	0	5994000
14	5999400	0	0	0	0	0	0	0	0	5999400

My measures look like this: 

OpeningBalanceCalc = CALCULATE(SUM('TS_Continuity (2)'[OpeningBalance]), FILTER('TS_Continuity (2)','TS_Continuity (2)'[EffectiveDate] = [MinDate]),ALL('TS_Continuity (2)'))

and 

ClosingBalanceCalc = CALCULATE(SUM('TS_Continuity (2)'[ClosingBalance]), FILTER('TS_Continuity (2)','TS_Continuity (2)'[EffectiveDate] = [MaxDate]))

I would appreciate any help 🙂 

Thanks,

Sebastian 

[amitchandak · Accepted solution]

@Anonymous , Move the min and max  date inside the calculation if you want data by month

example

OpeningBalanceCalc = CALCULATE(SUM('TS_Continuity (2)'[OpeningBalance]), FILTER(allselected('TS_Continuity) (2)','TS_Continuity (2)'[EffectiveDate] = min('TS_Continuity (2)'[EffectiveDate] )),ALL('TS_Continuity (2)'))

and 

ClosingBalanceCalc = CALCULATE(SUM('TS_Continuity (2)'[ClosingBalance]), FILTER(allselected('TS_Continuity )(2)','TS_Continuity (2)'[EffectiveDate] = max(TS_Continuity (2)'[EffectiveDate] )))

[Anonymous]

Thank you so much! It almost worked, I just needed to take away the first "allselected". Here is the final solution I used. Again, thanks so much!

OpeningBalanceCalc = CALCULATE(SUM('TS_Continuity (2)'[OpeningBalance]), FILTER('TS_Continuity (2)','TS_Continuity (2)'[EffectiveDate] = min('TS_Continuity (2)'[EffectiveDate])),ALL('TS_Continuity (2)'))