Forum Discussion

gprg's avatar
gprg
Regular Visitor
8 years ago

PowerPivot - Measure

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

powerbi

1 Reply

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    8 years ago

    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