Learning

Hi nandukrishnavs 

A better formulation of your measure is this:

2019-20 ACTUAL Income EXCL 100 =
	CALCULATE (
	    [2019-20 Totals],
	    KEEPFILTERS(
	    	BIGL_BSCC_DATA_181920[ACCT_CATEGORY] <> "100"
	    ),
	    KEEPFILTERS(
	    	'BIGL_GL_DATA_181920V2'[INCOME_EXP]  = "ACTUAL Income"
	    )
	)

It's better in 2 ways. First, it's a bit less to type. Second, it's more performant for 2 reasons:

1) you should not put a full table as a filter in CALCULATE if there's no real need (there seldom is),

2) KEEPFILTERS is faster.

And the golden rule of DAX says: Never filter a table when you can filter a column.

All these things can be discovered through www.sqlbi.com, the site by The Italians.

Best

D