Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Simple multiplication with quick measure?

 

Hi, I am going crazy?! 3 secs in Excel, 2 hrs in PowerBI......

I am simply trying to multiply 1 column by a percentage value from another column, using the quick measure button.... I have tried using MAX and Sumx etc..... This should be like instant, what I am missing/doing wrong?

 

 

 

 

This is simply EAX x RPI.... is the Max the right value to use?

Need Help

7 Replies

  • camargos88's avatar
    camargos88
    Icon for Community Champion rankCommunity Champion
    6 years ago

    Hi Anonymous ,

     

    If those tables are related, use the SUMX function.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi, I just hit a wall with this? I though max was the usual one too.....

       

       

  • v-juanli-msft's avatar
    v-juanli-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi Anonymous 

    We are all here to help you, so please don't be too anxious.

    What is the relationship between the two tables?

     

    Best Regards

    Maggie

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      HI, I am a Dax M language type of person, but am able to steal and amend a few calcs here and there......This seems very complicated.....However, I do not a have grasp as an MS Access user of uniqueness and row level joins etc...... I am guessing/assuming that the column data is not tight enough, so are the rows mis-joining and not aligning properly, so rogue values are being grouped intra row? Do I need to create a calculated column and concat a load of col values to force a stronger "perfect" unique join and then apply the calc? I know thats not Dax'style or purist, as I am just looking for a dirty workaround that works that I can understand as a none programmer....? 😞...... I also get confused as to whether its better to create new tables at transfomration stage and rejoin them than apply measures after the event...... i.e. receive data, break it down into logical chunks, then glue it back together using keys etc.....(a bit like I am suggesting above?)....