Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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.
User | Count |
---|---|
69 | |
43 | |
21 | |
21 | |
14 |
User | Count |
---|---|
124 | |
42 | |
39 | |
28 | |
25 |