Semi Additive Measures

Hi @spenser.steele, yes there is now! (and it actually works using omni_dimensionalize as a mechanism).
Check out this blog for more details and a walkthrough video: Omni LOD Blog

I think you’d want to use the “fixed grouping” option which will make the resulting CTE grouped by the dimensions you choose rather than mirroring the outer query.

1 Like