Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Solved! Go to 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
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
Hi!
Can you please reupload the pbix file?
Thank you!
My friend thank a lot!
precious helpppppp 🙂
thanks
have a nice day
Alessio
User | Count |
---|---|
141 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
123 | |
101 | |
71 | |
61 |