Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
souvik900766
Helper IV
Helper IV

Stop rolling up of data in table visual

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
rollup.PNG

 

Thanks in advance !

1 REPLY 1
Anonymous
Not applicable

Hi @souvik900766 

 

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.

Helpful resources

Announcements
PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

Top Solution Authors