Measure calculation between two matrix visuals

[DavePowerBI]

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?

 

[amitchandak]

@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.

[DavePowerBI]

@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

[DavePowerBI]

@amitchandak - here's the two data for the two matrix visual which is required with measure requited. Thank you

 

[DavePowerBI]