Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Multiplay with Measure & Column without expression

Dear Bro & Sis

In a Table I have a measure Value & a Column value, now need to multiply with the two values without the "sum expression" .

For the "sum expression," I'm not getting individual id wise values.

Please help

 

 

 

Tips and Tricks

3 Replies

  • v-xiaotang's avatar
    v-xiaotang
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi Anonymous 

    Thanks for reaching out to us.

    You can try this measure: 

    Per person Tk= 'Marge Data'[Per Weight TK]*min('Marge Data'[Weight.])

    If this doesn't help, could you share some sample data, and could you show your expected outcome (expected values) in that image? Thanks.

     

    Best Regards,

    Community Support Team _Tang

    If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      It is not working

      • v-xiaotang's avatar
        v-xiaotang
        Icon for Community Support rankCommunity Support
        4 years ago

        Hi Anonymous 

        Thanks for your reply.

        Information is not enough to go on.... 

        usually information below is needed, could you provide it? Thanks.

         (1) a sample file, you can replace raw data with bogus data to protect your privacy.

             or provide some sample data that fully covers your issue/question.

        (2) give your expected result and its math formula based on the sample you provide.

         

        Thanks.

         

         

        Best Regards,

        Community Support Team _Tang

        If this post helps, please consider Accept it as the solution to help the other members find it more quickly.