Forum Discussion
DavePowerBI
3 years agoFrequent Visitor
Measure calculation between two matrix visuals
Hi all, I am new here and am currently stuck on a measure calculation+ not sure if this is possible to do. I have no data relationships built and I am using only one .xls file. I have two matrix vis...
amitchandak
3 years agoSuper User
DavePowerBI , Not very clear , but seem like you need two measures with required filters
If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
- DavePowerBI3 years agoFrequent Visitor
amitchandak - please find all data below
Phone
Storage
colour
number
A
128
Blue
1
B
256
green
2
C
512
yellow
1
D
128
pink
2
A
512
pink
1
B
128
blue
2
C
128
pink
1
D
512
blue
2
A
256
green
1
B
512
green
2
C
256
yellow
1
D
256
blue
2
A
128
green
1
B
512
blue
2
C
256
blue
1
D
128
pink
2
A
512
yellow
1
B
128
pink
2
C
512
green
1
D
512
pink
2
A
512
green
1
B
512
yellow
2
C
512
blue
1
D
512
pink
2
- DavePowerBI3 years agoFrequent Visitor
amitchandak - here's the two data for the two matrix visual which is required with measure requited. Thank you
ā
- DavePowerBI3 years agoFrequent Visitor
ā