Hi @haileysims, This is possible, however a derived table would need to be created. We can have this be dynamic by dimensionalizing the measure through the derived table. I understand you did not want to do this in LookML, however for the time being ...

Hi Subhasree, I’d love to investigate why you are seeing this error. I would be able to assist better if you e-mail help.looker.com. It would also be really helpful if you provided a screenshot of the LookML that is returning this error. Best, Anakar...