Forum Discussion
Create Matrix counting rows from sliced data
Yes, Region and District are in Rows, Count of RTAs, etc. are in Values, using Count (Distinct).
Here is some data:
| Region | District | Total RTAs | Filtered RTAs |
| Atlantic | Capitol District | 9 | 9 |
| Atlantic | Capitol District | 13 | |
| Atlantic | Capitol District | 11 | |
| Atlantic | Capitol District | 2 | 2 |
| Atlantic | Capitol District | 3 | 3 |
| Atlantic | Capitol District | 4 | 4 |
| Atlantic | Capitol District | 2 | 2 |
| Atlantic | Capitol District | 0 | 0 |
| Atlantic | Capitol District | 0 | 0 |
| Atlantic | Capitol District | 23 | |
| Atlantic | Capitol District | 7 | 7 |
| Atlantic | Capitol District | 4 | 4 |
| Atlantic | Capitol District | 5 | 5 |
| Atlantic | Capitol District | 5 | 5 |
| Atlantic | Capitol District | 7 | 7 |
| Atlantic | Capitol District | 7 | 7 |
| Atlantic | Capitol District | 2 | 2 |
| Atlantic | Capitol District | 15 | |
| Atlantic | Capitol District | 1 | 1 |
| Atlantic | Capitol District | 7 | 7 |
| Atlantic | Capitol District | 15 | |
| Atlantic | Capitol District | 7 | 7 |
| Atlantic | Capitol District | 3 | 3 |
| Atlantic | Capitol District | 8 | 8 |
| Atlantic | Capitol District | 3 | 3 |
| Atlantic | Capitol District | 4 | 4 |
| Atlantic | Capitol District | 6 | 6 |
| Atlantic | Capitol District | 0 | 0 |
| Atlantic | Capitol District | 9 | 9 |
| Atlantic | Capitol District | 8 | 8 |
| Atlantic | Capitol District | 3 | 3 |
| Atlantic | Capitol District | 10 | |
| Atlantic | Capitol District | 2 | 2 |
| Atlantic | Capitol District | 3 | 3 |
| Atlantic | Capitol District | 0 | 0 |
| Atlantic | Capitol District | 19 | |
| Atlantic | Capitol District | 4 | 4 |
| Atlantic | Capitol District | 19 | |
| Atlantic | Capitol District | 15 | |
| Atlantic | Capitol District | 1 | 1 |
| Atlantic | Capitol District | 14 | |
| Atlantic | Capitol District | 1 | 1 |
| Atlantic | Capitol District | 0 | 0 |
| Atlantic | Capitol District | 1 | 1 |
| Atlantic | Capitol District | 1 | 1 |
| Atlantic | Capitol District | 8 | 8 |
| Atlantic | Capitol District | 0 | 0 |
| 47 | 37 |
Whaat's missing in the above data is the Advisor Name, which was necessary in order to give me the distinct values to sort. "Filtered RTAs" is actually the measure I used, which results in "1" for each line, which when summed is 37.
This is what the matrix should look like, but the "Count (Distinct)", which is counting the distinct number of Advisor Names, returns 17 rather than 37.
| Region | Count of RTAs |
| Atlantic | 37 |
| Capitol District | 37 |
| Total | 37 |
I get similar results from the other 2 products as well, so if I can figure out the problem here, I can apply that to the others as well.
Hi tborg,
From the data you provided, the Count of Filtered RTAs is 37. But how Count of RTAs be calculated, as there should be a column contains RTAs values.
If your report doesn't contain sensitive data, would you please share pbix file here? As the sample data you provided seems not raw data but aggregated results from a visual. Please share raw data from Data tab like below which used in the matrix visual.
Best Regards,
QiuyunYu