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
rodfernandez
Helper I
Helper I

Display Don't summarize values in matrix visual

Hello 🙂
I have 2 tables 

IdzoneAmount
1North10
2South15
3North5
4South6
5North4
6North12
7South15
8North3
9South9
10North11
11South15
12South4
13North2
14South12
15South4
16North14
17South10
18South4
19North13
20South3

 

ZoneGoal
North100
South 110

 

And I need to create this Visualization Matrix 

 SouthNorth Total
Goal110100210
Amount9774171

Compliance 
88%74%81%

 

Where Amount is the sum from the amount form the first table for each zone 
Goal is just the value from the second table without any operation (I am having trouble doing this part).
The last row is just the % for each zone (Amount.South/Goal.South and the same for the North).

 

I am having trouble showing just the value in the first row without any operation, maybe I’m not relating the 2 tables in a good way.... 


Thanks

1 ACCEPTED SOLUTION
themistoklis
Community Champion
Community Champion

@rodfernandez

 

Please have a look at the workspace on this link

It shows the matrix as you described it on your message

View solution in original post

1 REPLY 1
themistoklis
Community Champion
Community Champion

@rodfernandez

 

Please have a look at the workspace on this link

It shows the matrix as you described it on your message

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.