Forum Discussion
cross calculation in matrix chart
Hi,
PBi file attached.
Hope this helps.
Super UserPlease 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-Forum/ba-p/963216
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
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
Hi,
PBi file attached.
Hope this helps.
