cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
rodfernandez Frequent Visitor
Frequent Visitor

Display Don't summarize values in matrix visual

Hello Smiley Happy
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

Accepted Solutions
themistoklis New Contributor
New Contributor

Re: Display Don't summarize values in matrix visual

@rodfernandez

 

Please have a look at the workspace on this link

It shows the matrix as you described it on your message

1 REPLY 1
themistoklis New Contributor
New Contributor

Re: Display Don't summarize values in matrix visual

@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
Community Highlights

Community Highlights

Find out what's new in the Power BI Community!

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 253 members 2,723 guests
Please welcome our newest community members: