Forum Discussion
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 visuals which I have created which include filtering. I need to do a calculation which can be added besides column Tktcount Mat.
Lookup same country TktCount Mat ÷ TktCount Trx Total and show in %, so for Switzerland this would be 1÷308 = 0.003247 convert to 0.32%
Would be great if someone can provide assistance please?
4 Replies
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.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
amitchandak - here's the two data for the two matrix visual which is required with measure requited. Thank you
