cross calculation in matrix chart

[DanCasSan20]

Hello community,

I ask you for help for a particular calculation, I have a table under the name f_evaluacion_diagnostico, in which I have 2 columns: evaluation_result and result_verification. In a matrix chart, I need to show the transition of the results of the first field, for example: "START" to "ACCOMPLISHED" where "START" corresponds to the evaluation_result field and "ACCOMPLISHED" to the verification_result field, how could I do it?

In this image I detail better what I need.

Thank you very much for your help!

Greetings,
D.C.

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

[DanCasSan20]

Hello @lbendlin ,

Here I share some fictitious data so you can understand what I need, in the first column are the results of the initial evaluation and in the second column the results of the final evaluation, what I need is to put the results in rows and columns and count how many There is from the initial evaluation to the final one, as I show in the second table:

diag_result	veri_result
INI	PROC
INI	LOG
LOG	INI
LOG	PROC
PROC	PROC
INI	INI
INI	INI
PROC	INI
LOG	LOG
LOG	LOG
LOG	PROC
INI	LOG
INI	INI
INI	INI
LOG	LOG
PROC	PROC
INI	LOG
LOG	PROC
LOG	INI
PROC	INI
INI	INI
PROC	PROC

This is the table I want to have as a result:

	veri_result
diag_result	INI	PROC	LOG
INI	5	1	3
PROC	2	3	0
LOG	2	3	3

Thanks for your help!

Regards!

DC

[Ashish_Mathur · Accepted solution]

Hi,

PBi file attached.

Hope this helps.