Set analysis with master measure

Stanislav1 — Wed, 05 Feb 2025 08:50:06 GMT

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?

Re: Set analysis with master measure

Clement15 — Wed, 05 Feb 2025 09:25:20 GMT

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)

topic Set analysis with master measure in App Development

Set analysis with master measure

Re: Set analysis with master measure