Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good afternoon!
I saw multiple posts of how can I reuse master measure, but it doesn't work in my case. I tried with using variables and then referencing the variable, but still doesn't work. My expression is simple.
I have master measure: msr171 (Period), it is a big measure using SUM as aggregating function
$(vL.AdsCostAPA) is a variable which golds the value of msr171 (Period)
I want to use set analysis to further narrow down to Ad Network = 'Apple Search Ads'
I am trying to do the following: ONLY({<[Ad Network]={"Apple Search Ads"}>} $(vL.AdsCostAPA))
However, I get the error "Nested aggregation not allowed". How can I get around it?
Hello,
$(vL.AdsCostAPA) has a structure like sum(Measure) ? You can't do only(sum(...)). If your goal is just to add the set analysis you can use this:
={<[Ad Network]={"Apple Search Ads"}>}$(vL.AdsCostAPA)
Hello,
$(vL.AdsCostAPA) has a structure like sum(Measure) ? You can't do only(sum(...)). If your goal is just to add the set analysis you can use this:
={<[Ad Network]={"Apple Search Ads"}>}$(vL.AdsCostAPA)