Expression doesn't work after adding data

[kennethand]

I have this expression

Sum({ <Uniq_ID=,q16udland-={"Udlandet"}>}Aggr(Only([weight]), Uniq_ID))

/

Sum({ <q16udland-={"Udlandet"},Kommune={*}>} [weight])

which gives me this this chart (how many percent of the selected "Kommune" )

So far so good.

But when I add this small data sample the expression doesn't work anymore (gives me 100%):

[BefolkningKommune]:

LOAD

                           [Kommune],

                           [Periode],

                           [Kommune Size]

FROM [lib://DK-stat/Befolkning.xlsx]

(ooxml, embedded labels, table is BefolkningKommune);

New data is just telling me the size of every "Kommune" (Community) in Denmark per Period.

The question is: How do I change my expression in order to work even if I add the new data? Changing the fieldnames is not an option.

[agigliotti]

could you share a sample app with mock data ?

[bwisealiahmad]

Hi,

I Agree with Andrea. Would be great with some example data. Do you get any synthetic keys when doing this?

Best,

Ali A

[kennethand]

Thanks for your intention of helping. I think I found a get around.

[kennethand]

Thanks for your intention of helping. I think I found a get around.