Getting totals from 2 matrices in a third matrix

[ecoale]

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.

[v-diye-msft · Accepted solution]

Hi @ecoale 

I created a sample same as yours, but calculate the percentage using calculated column instead of measure:

2015 = IF('2015'[Sex]="n.d",BLANK(),DIVIDE('2015'[Number],CALCULATE(SUM('2015'[Number]),FILTER(ALL('2015'),'2015'[Sex]="F"||'2015'[Sex]="M"))))

2018 = IF('2018'[Sex]="n.d",BLANK(),DIVIDE('2018'[Number],CALCULATE(SUM('2018'[Number]),FILTER(ALL('2018'),'2018'[Sex]="F"||'2018'[Sex]="M"))))

And then the third matrix could be generated with the total percentage

Pbix attached here for your reference: https://wicren-my.sharepoint.com/:u:/g/personal/dinaye_wicren_onmicrosoft_com/EdbOuB01DW5KulBtcp90dO...

Best regards,

Dina Ye

[ZoltanHorogh]

Hi!

Can you please reupload the pbix file?

Thank you!

[ecoale]

My friend thank a lot!

precious helpppppp 🙂

thanks

have a nice day

Alessio