Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi !
I have two table visuals one showing segment level and other showing OU level data
I want to see Basket Incidence of Segment thats trips/ fmcg trips.
My results are calculated through measures.
My problem is my data is rolling up.
Now,
for EMEA in seg all rows of trips is rolling up from OU i.e.(E&ME +Europe +Africa) and then it is coming as numerator (C2) and then it is getting divided by B2. This is wrong !
What I want or my expected result is that it should only take Europe in OU (C9) as I have value FMCG trips (B9) only for that row.
So it sholud be 123/2694.
Answer:- E2/B2 = F2
Thanks in advance !
The fact nobody has yet replied to your question means nobody understands it. Please rephrase your problem in simpler, clearer terms. If you want a guide on how to get your questions answered quickly, please refer to THIS POST.