Use data from Matrix for other graphs

[panoslaz]

Hi 

I have a list client data, amongst which there is information about the country they come from. 

I have a qualitative variable (say delivered / not delivered)

I want to create a map-graph with the countries being for example green if more than 70% is delivered. 

I am not good in DAX. 

I thought of creating a matrix, calculating the values for each country. At this point, i want to use the matrix data to either create a new dataset or directly use them for a graph. 

Is there any way?

thanks 

[danextian]

We can't stress this enough. Pleae provide a sample data. 🙂

[panoslaz]

Hi

Thanks for replying, 

THe first columns of my dataset are like below:

SUB REGION CODE	Country	Client	identified	status
GEO0069	Germany	A	1	Delivered
GEO0069	Germany	B	5	Delivered
GEO0069	Germany	C	3	Not delivered
GEO0069	Germany	D	6	Not delivered
GEO0069	Germany	D	8	Not delivered
GEO0069	Germany	C	23	Not delivered
GEO0069	Germany	G	4	Not delivered
GEO0069	Germany	A	2	Stable
GEO0069	Germany	B	2	Not delivered
GEO0069	Germany	C	6	Not delivered
GEO0069	Germany	F	8	Not delivered
GEO0023	India	A	32	Not delivered
GEO0023	India	C	2	Stable
GEO0069	Italy	A	4	Not delivered
GEO0069	Italy	B	45	Not delivered
GEO0069	Italy	C	1	Stable
GEO0069	Italy	D	4	Delivered
GEO0069	Italy	F	5	Delivered
GEO0069	Italy	F	6	Not delivered
GEO0069	Italy	F	7	Not delivered
GEO0022	Malaysia	A	4	Not delivered
GEO0022	Malaysia	B	2	Not delivered
GEO0022	Malaysia	C	54	Not delivered
GEO0022	Malaysia	D	8	Stable
GEO0022	Malaysia	G	4	Not delivered

I have another 68 columns in the dataset, for many different metrics for each line. 

My PBI report is focused on the metrics of each line but i want to include an overview of how we perform per country, showing a map that simply would be green if more than 70% of the cells in each country is Delivered. 

I am aware that there would be a DAX solution but i am not really confident yet on coding in DAX.

I found out that a matrix visual can providem e the info i need so I wanted to know if i can use the output of matrix to create other graphs, like the map. 

For now i just exported the matrix in cvs and re-uploaded it but i assume there would be a better way

thanks