LinkedIn
Twitter
Hi Team,
What is the straightforward way to implement Semi Additive Measures in LookML using functions and calculations for any slice and dice by the users. This is not using insanely complex pre-calculation, derived table, crazy joins in LookML. We are doing a Looker PoC and if semi additive measures are not possible in modelling calculations in a simple way then Looker fails the PoC.
Even after so many years it is shocking there is not a single solution on the web for a LookML function to perform semi additive measure. Looker promises this in this blog but has not delivered at all. Semi additive are the hardest measures and a self promoting Analytical tool like Looker has not provided any solution.
The approach mentioned by @fabio1 in this post is not the analytical way and is terribly inefficient, complex requiring pre-calculations, lines of code, restricted slice and dice.
Azure Analysis Services and Power BI have an easy straightforward 1 line code to implement in the model.
CALCULATE
(
SUM('ARR'[arr_amt_usd]),
FILTER(ALL('Calendar'[Date]),'Calendar'[Date]=MAX('ARR'[ReportDate]))
)
Thanks
