Calculation between 2 tables

[Wresen]

Hi , and thanks for reading this.

I am still learing this but and i have hit a litte bump on the road.

I have 2 tables

I have a relationship between Month and Month (one to one, both)

The Measure 2 is  "Measure 2 = (SELECTEDVALUE(test2[matte])* SELECTEDVALUE(test[value]))"

How can i make so if i remove "month"  a Sum of the Measure 2 value

If i remove  month :

(i would like it to show the sum of measure 2 =35 in line with 2019 and 11)

Thanks so much

[az38 · Accepted solution]

Hi @Wresen 

try this

Measure 2 = calculate(sumx(test;calculate(sum(test2[Matte]))*calculate(sum(test[value]))))

[Wresen]

Thanks so much.

That worked perfect.

I think i need to readup on SUMX to understand what i going on

Thanks again

[az38]

@Wresen 

well, if try to descripe it simple:

sum - is a sum of values from one exactly column (maybe with some filters)

sumX - is a sum of a calculated expressions which could use more than one column

[Wresen]

Sorry for late answer.

Thanks so much for the help

I have one more strange question regarding this.

How do i use a IF statment in this example.

The table "test2" does not excist and and want to:

If test.month =1 then value *2 ; If test.month =2then value *3;If test.month =3 then value *4

I also want the claculation to be correct when i remove month.

I hop i have manages to explain myslef.

[az38]

Hi @Wresen 

create new calculated column in the table 1 with IF statement then multiply as you wish

...if i understand you correct 🙂

[Wresen]

Hi Az38 ;and Thanks for helping

It needs to be a mesure since the multiplyed value will change depening on filters (if i managed to make the report)

We have this table , and i want to make a measure that checks the month and depeding on month it will multiply with a number.

If (month = 1 then value *2;If (month = 2 then value *3;If (month = 2 then value *4;

and when i remove month  and value i want the still be there

So if it would work i would have Measure to the right of year and a value 35