PowerPivot - Measure

[gprg]

Hi together, short question in the round: I want to isolate and read the value 2 from different columns of a table.
The columns awa60 to wa63 can store three different values: 0, 1 and 2.

For example:

=calculate(SUM(ca[awa60]);ca[awa60])=2+
calculate(SUM(ca[awa60]);ca[awa61])=2+
calculate(SUM(ca[awa60]);ca[awa62])=2+
calculate(SUM(ca[awa60]);ca[awa63])=2

My measure does not work. Can someone help? greetings Guenter

[v-yulgu-msft]

Hi @gprg,

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 forum.

Regards,

Yuliana Gu