Forum Discussion
Helper IGetting totals from 2 matrices in a third matrix
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/EdbOuB01DW5KulBtcp90dOcBbvNGHfSAxOlpEK3yYgS7Wg?e=dyE8Xv
Best regards,
Dina Ye
Community SupportHi 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/EdbOuB01DW5KulBtcp90dOcBbvNGHfSAxOlpEK3yYgS7Wg?e=dyE8Xv
Best regards,
Dina Ye
Hi!
Can you please reupload the pbix file?
Thank you!