Simple multiplication with quick measure?

[Anonymous]

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?

[v-juanli-msft]

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]

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?)....

[v-juanli-msft]

Hi @Anonymous 

Firstly learn some basic techniques:

https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-create-and-manage-relationships

https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-quickstart-learn-dax-basics

https://docs.microsoft.com/en-us/dax/dax-overview

Later i would create a simple example to help you understand your problem.

Best Regards

Maggie

[camargos88]

Hi @Anonymous ,

If those tables are related, use the SUMX function.

[Anonymous]

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

[amitchandak]

@Anonymous , You need have common group by or dimension where you can group this data and multiply

Like

Sumx(summarize(Dimension,Dimension[Dim],"_1",sum(MergeData[EAC]) , "_2",sum(BasecaseRpiX[Percent Indextaion])),[_1]*[_2])

Refer, how I have taken advantage order dim to take date diff

https://community.powerbi.com/t5/Community-Blog/Decoding-Direct-Query-in-Power-BI-Part-2-Date-Difference-Across/ba-p/934397#M451

[camargos88]

@Anonymous ,

SUMX(TABLE, COLUMN X COLUMN)