Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi everybody,
I have a matrix with two fields in "Columns", but in the "Total" column I just see the final big total, and not the total for each value in the columns.
As shown in the picture, I should find the total, for the whole week, of Full Price and Outlet, but I just see the big total.
How can I solve the problem?
Solved! Go to Solution.
Hi @Lodoardi,
In the Matrix visual, Total Column is returning total for the outmost layer column group instance, so what you get is expected.
Currently, the matrix doesn't support custom total values. In your scenario, to work around the issue, you can create another matrix, place the field contains %Full and %Out, and Year-Semester in Rows, and value field in Values.
Best Regards,
Qiuyun Yu
Can you explain a little more about what you want? If I add the bold items in the first row, this adds up to the Total at the end for that row, which seems proper but obviously is not what you want?
I assume Total is a measure?
Values are good, I wrote the measure to give me a different total (you can see that the sum of full price and outlet is aalways 100 even if the total is different). What I want is to have the last bold column called "Total" divided (like the others) by Full Price and Outlet, and finally the Total of everything. Insted I just have the Total of everything.
In the following image (I found it in the web) There is part of this kind of total I'm describing.
Tanks.
OK, trying to wrap my head around this. Are you saying that you want the total "% Full" and Total "% Out" at the end of the row so that you know what total % was Full vs. Outlet, or do you want to know the Amount of Full vs. Outlet in $$?
I want these three columns on the right end: "Total % Full Price", "Total % Outlet" (as you said) and finally "Total" (The only column that I already have).
Hi @Lodoardi,
In the Matrix visual, Total Column is returning total for the outmost layer column group instance, so what you get is expected.
Currently, the matrix doesn't support custom total values. In your scenario, to work around the issue, you can create another matrix, place the field contains %Full and %Out, and Year-Semester in Rows, and value field in Values.
Best Regards,
Qiuyun Yu
User | Count |
---|---|
103 | |
90 | |
78 | |
72 | |
68 |
User | Count |
---|---|
110 | |
96 | |
95 | |
74 | |
71 |