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

Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM. Register now.

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
October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.