Filter blanks from calculated table based on measure

[JMac_WandB]

Hi all,

Hopefully a simple solution: I have a calculated table which brings in a measure (NTA_Ch) which is working fine, my issue is adding a FILTER to exclude values where the measure does not apply. It currently includes a first row (-100%) that shouldn't be calculated and also trailing values (pictured).

I had expected to be able to include "FILTER (Table, underlying number <> BLANK())" however this seems to change the context of the measure and break the calculation? Any thoughts on a way around this? 

NTA_MoM2 =

CALCULATETABLE(

ADDCOLUMNS(

SUMMARIZECOLUMNS('Date_Ref$'[Cal_Period],Summary[Code]),

"NTA_MoM", [NTA_Ch])

)

trailing values are zerofirst value shouldn't exist

[Jihwan_Kim]

How does the measure [NTA_Ch] look like?

[JMac_WandB]

Hi Jihwan,

It is a calculation based on a series of other calculations:

NTA_Ch = iferror(([NTA_Total_Return]/[TR_LastMonth2])-1, BLANK())

[Jihwan_Kim]

Please share the sample pbix file's link.

[JMac_WandB]

https://drive.google.com/file/d/1PfUWbYv9laTah8Y0f0Kd2hMfPQHykCVc/view?usp=sharing 

[Jihwan_Kim · Accepted solution]

Sorry, but I cannot fully understand the related tables and measures.

Please try the below whether it suits your request. I think you can add more conditions to the below if you need more to filter.

NTA_MoM2 =

FILTER(

SUMMARIZECOLUMNS('Date_Ref$'[Cal_Period],Summary[Code],

"NTA_MoM", [NTA_Ch]), [NTA_MoM]<>-1)

[JMac_WandB]

Many thanks Jihwan, Looks like this will do the trick.