Forum Discussion
Solved
Filter blanks from calculated table based on measure
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 a...
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)
Jihwan_Kim
Super User
Super UserHow does the measure [NTA_Ch] look like?
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.
- Jihwan_Kim
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)