Values if an other value is not blank
Hi, I have a problem. I want to delete SqMeters values when Sold has no values. What i want: I have tried different measures but if I try to write: IF([Sold], sum[SqMeters]) or Sold/Sqm = CALCULATE( sum([SqMeters], FILTER ( VALUES ( Table[Store] ), [Sold] <> BLANK () ) ) these measures always return me an error where it tells me that the memory required for this calculation exceeds the available memory or a generic error. How could I write a measure so that the SqMeters value is removed when Sold is blank? Thank you!
