Forum Discussion

ecoale's avatar
ecoale
Icon for Helper I rankHelper I
7 years ago
Solved

Getting totals from 2 matrices in a third matrix

Hi friends, I really need help :(

 

I have 2 matrices (years 2015 and 2018) with the distribution of students for sex (number and %):

2015:                                 2018:

M: 10, 33,3%                     M: 15, 55,6%

F: 20, 66,7%                       F: 12, 44,4%

n.d.: 1                                n.d.: 3

total: 31                            total: 30

PS the % were got, in PBI desktop, dropping the coloumns "number of students" in values, and then filtering excluding the not available (n.d.)

 

Now, I need to find the way (I mean automaticly with DAX, not manually) to get a third matrix showing the two distribution %:

              2015    2018

M:          33,3%  55,6%

F:            66,7%  44,4%

total:  100,0%  100,0%

 

I tried lots of ways... but I do not find anything... anybody could help me please??

Thanks a lot in advance.

3 Replies