https://community.fabric.microsoft.com/t5/Report-Server/PowerPivot-Measure/m-p/347860#M3655 <P>Hi together, short question in the round: I want to isolate and read the value 2 from different columns of a table.<BR />The columns awa60 to wa63 can store three different values: 0, 1 and 2.</P><P>For example:</P><P>=calculate(SUM(ca[awa60]);ca[awa60])=2+<BR />calculate(SUM(ca[awa60]);ca[awa61])=2+<BR />calculate(SUM(ca[awa60]);ca[awa62])=2+<BR />calculate(SUM(ca[awa60]);ca[awa63])=2</P><P><BR />My measure does not work. Can someone help? greetings Guenter</P> Tue, 30 Jan 2018 08:07:15 GMT gprg 2018-01-30T08:07:15Z https://community.fabric.microsoft.com/t5/Report-Server/PowerPivot-Measure/m-p/347860#M3655 <P>Hi together, short question in the round: I want to isolate and read the value 2 from different columns of a table.<BR />The columns awa60 to wa63 can store three different values: 0, 1 and 2.</P><P>For example:</P><P>=calculate(SUM(ca[awa60]);ca[awa60])=2+<BR />calculate(SUM(ca[awa60]);ca[awa61])=2+<BR />calculate(SUM(ca[awa60]);ca[awa62])=2+<BR />calculate(SUM(ca[awa60]);ca[awa63])=2</P><P><BR />My measure does not work. Can someone help? greetings Guenter</P> Tue, 30 Jan 2018 08:07:15 GMT https://community.fabric.microsoft.com/t5/Report-Server/PowerPivot-Measure/m-p/347860#M3655 gprg 2018-01-30T08:07:15Z https://community.fabric.microsoft.com/t5/Report-Server/PowerPivot-Measure/m-p/348712#M3689 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="53263" data-lia-user-login="gprg" class="lia-mention lia-mention-user">gprg</a>,</P> <P>&nbsp;</P> <P>Could you please provide more description about your requirement? Please share sample data in source table and show us your desired output with example. Besides, if you were encountering problem in PowerPivot, I would suggest you post question on more related <A href="https://social.msdn.microsoft.com/Forums/sqlserver/en-US/home?forum=sqlkjpowerpivotforexcel" target="_self">forum</A>.</P> <P>&nbsp;</P> <P>Regards,</P> <P>Yuliana Gu</P> Wed, 31 Jan 2018 06:54:15 GMT https://community.fabric.microsoft.com/t5/Report-Server/PowerPivot-Measure/m-p/348712#M3689 v-yulgu-msft 2018-01-31T06:54:15Z