topic Display multiple columns value with reference to 2 columns in Desktop
https://community.powerbi.com/t5/Desktop/Display-multiple-columns-value-with-reference-to-2-columns/m-p/543358#M255730
<P>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. </P><TABLE><TBODY><TR><TD>Column A</TD><TD>Column B</TD><TD>Column R</TD><TD>Column 4</TD><TD>Column W</TD><TD>Column D</TD></TR><TR><TD>2</TD><TD>3</TD><TD>1</TD><TD>0</TD><TD>1</TD><TD>0</TD></TR><TR><TD>1</TD><TD>5</TD><TD>3</TD><TD>1</TD><TD>1</TD><TD>0</TD></TR><TR><TD>4</TD><TD>2</TD><TD>4</TD><TD>1</TD><TD>1</TD><TD>1</TD></TR><TR><TD>5</TD><TD>1</TD><TD>5</TD><TD>1</TD><TD>0</TD><TD>0</TD></TR><TR><TD>2</TD><TD>3</TD><TD>6</TD><TD>0</TD><TD>1</TD><TD>1</TD></TR><TR><TD>3</TD><TD>4</TD><TD>2</TD><TD>0</TD><TD>0</TD><TD>1</TD></TR><TR><TD>5</TD><TD>3</TD><TD>3</TD><TD>1</TD><TD>1</TD><TD>1</TD></TR><TR><TD>3</TD><TD>1</TD><TD>1</TD><TD>1</TD><TD>0</TD><TD>0</TD></TR><TR><TD>4</TD><TD>2</TD><TD>2</TD><TD>0</TD><TD>1</TD><TD>1</TD></TR><TR><TD>1</TD><TD>1</TD><TD>3</TD><TD>1</TD><TD>0</TD><TD>1</TD></TR><TR><TD>1</TD><TD>3</TD><TD>5</TD><TD>0</TD><TD>1</TD><TD>0</TD></TR><TR><TD>1</TD><TD>2</TD><TD>6</TD><TD>1</TD><TD>0</TD><TD>1</TD></TR></TBODY></TABLE>Tue, 16 Oct 2018 11:54:36 GMTJAVED2018-10-16T11:54:36ZDisplay multiple columns value with reference to 2 columns
https://community.powerbi.com/t5/Desktop/Display-multiple-columns-value-with-reference-to-2-columns/m-p/543358#M255730
<P>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. </P><TABLE><TBODY><TR><TD>Column A</TD><TD>Column B</TD><TD>Column R</TD><TD>Column 4</TD><TD>Column W</TD><TD>Column D</TD></TR><TR><TD>2</TD><TD>3</TD><TD>1</TD><TD>0</TD><TD>1</TD><TD>0</TD></TR><TR><TD>1</TD><TD>5</TD><TD>3</TD><TD>1</TD><TD>1</TD><TD>0</TD></TR><TR><TD>4</TD><TD>2</TD><TD>4</TD><TD>1</TD><TD>1</TD><TD>1</TD></TR><TR><TD>5</TD><TD>1</TD><TD>5</TD><TD>1</TD><TD>0</TD><TD>0</TD></TR><TR><TD>2</TD><TD>3</TD><TD>6</TD><TD>0</TD><TD>1</TD><TD>1</TD></TR><TR><TD>3</TD><TD>4</TD><TD>2</TD><TD>0</TD><TD>0</TD><TD>1</TD></TR><TR><TD>5</TD><TD>3</TD><TD>3</TD><TD>1</TD><TD>1</TD><TD>1</TD></TR><TR><TD>3</TD><TD>1</TD><TD>1</TD><TD>1</TD><TD>0</TD><TD>0</TD></TR><TR><TD>4</TD><TD>2</TD><TD>2</TD><TD>0</TD><TD>1</TD><TD>1</TD></TR><TR><TD>1</TD><TD>1</TD><TD>3</TD><TD>1</TD><TD>0</TD><TD>1</TD></TR><TR><TD>1</TD><TD>3</TD><TD>5</TD><TD>0</TD><TD>1</TD><TD>0</TD></TR><TR><TD>1</TD><TD>2</TD><TD>6</TD><TD>1</TD><TD>0</TD><TD>1</TD></TR></TBODY></TABLE>Tue, 16 Oct 2018 11:54:36 GMThttps://community.powerbi.com/t5/Desktop/Display-multiple-columns-value-with-reference-to-2-columns/m-p/543358#M255730JAVED2018-10-16T11:54:36ZRe: Display multiple columns value with reference to 2 columns
https://community.powerbi.com/t5/Desktop/Display-multiple-columns-value-with-reference-to-2-columns/m-p/544244#M255734
<P>Hi <LI-USER uid="78322"></LI-USER>,</P>
<P> </P>
<P>You can create a calculated column below: </P>
<P> </P>
<P>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]))</P>
<P> </P>
<P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="w3.PNG" style="width: 600px;"><img src="https://community.powerbi.com/t5/image/serverpage/image-id/126452i8A27E3FA54A405F7/image-size/large?v=v2&px=999" role="button" title="w3.PNG" alt="w3.PNG" /></span></P>
<P> </P>
<P>Best Regards,<BR />Qiuyun Yu </P>Wed, 17 Oct 2018 07:34:22 GMThttps://community.powerbi.com/t5/Desktop/Display-multiple-columns-value-with-reference-to-2-columns/m-p/544244#M255734v-qiuyu-msft2018-10-17T07:34:22ZRe: Display multiple columns value with reference to 2 columns
https://community.powerbi.com/t5/Desktop/Display-multiple-columns-value-with-reference-to-2-columns/m-p/548447#M257915
This is not the exact output but i got it in a different wayMon, 22 Oct 2018 09:56:14 GMThttps://community.powerbi.com/t5/Desktop/Display-multiple-columns-value-with-reference-to-2-columns/m-p/548447#M257915JAVED2018-10-22T09:56:14Z