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)
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)
Many thanks Jihwan, Looks like this will do the trick.