Display multiple columns value with reference to 2 columns

[JAVED]

Hi! I have a columnA and columnB with different numbers like 1,2,3,4,5 and 6,7,8,9,10. i have other coumns like R,4,W,D Now i have to display other columns like "If(a=1 and b=4 then sum(R),count(B),Count(W),Count(D))" i am no able t do in pwer bi exactly can uplease help me with this. 

Column A	Column B	Column R	Column 4	Column W	Column D
2	3	1	0	1	0
1	5	3	1	1	0
4	2	4	1	1	1
5	1	5	1	0	0
2	3	6	0	1	1
3	4	2	0	0	1
5	3	3	1	1	1
3	1	1	1	0	0
4	2	2	0	1	1
1	1	3	1	0	1
1	3	5	0	1	0
1	2	6	1	0	1

[v-qiuyu-msft · Accepted solution]

Hi @JAVED,

You can create a calculated column below: 

Column = IF('Table1'[Column A]=1 && 'Table1'[Column B]=4,SUM('Table1'[Column R])&","&COUNT(Table1[Column B])&","&COUNT('Table1'[Column W])&","&COUNT('Table1'[Column D]))

Best Regards,
Qiuyun Yu 

[JAVED]

This is not the exact output but i got it in a different way