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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
Anonymous
Not applicable

Why I get a duplicate and wrong value for certain column in power bi visualization into a table

 

When i do the visualization table for Nama blok skim utama & Purata hasil Padi kg/Plot UTT (as in the powerBi file), it gave a wrong data of any data that have 1 & 2 (ex: sawah sempadan1 & sawah sempadan. In the picture, SUM OF LM column are wrong only for data that have sub category such as Sawah Sempadan (Sawah Sempadan 1 & sawah sempadan 2 ). Panchang Bedena (1&2). @Anonymous @Jihwan_Kim https://drive.google.com/drive/folders/1AQXm0SyWI8jpCZ1KJSQvqQHR6AXwZkDh?usp=sharing 
Nama UTT.pngutt2.png

 

 

1 REPLY 1
lbendlin
Super User
Super User

Correct your data model

lbendlin_1-1690148164309.png

 

and use the dimension fields for the grouping.

See attached.

lbendlin_0-1690148137744.png

 

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

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.

Top Solution Authors
Top Kudoed Authors