Forum Discussion

Wresen's avatar
Wresen
Post Patron
6 years ago
Solved

Calculation between 2 tables

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

 

 

Need Help
  • az38's avatar
    az38
    6 years ago

    Hi Wresen 

     

    try this

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

6 Replies

  • az38's avatar
    az38
    Community Champion
    6 years ago

    Hi Wresen 

     

    try this

    Measure 2 = calculate(sumx(test;calculate(sum(test2[Matte]))*calculate(sum(test[value]))))
    • Wresen's avatar
      Wresen
      Post Patron
      6 years ago

      Thanks so much.

      That worked perfect.

       

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

       

      Thanks again

       

      • az38's avatar
        az38
        Community Champion
        6 years ago

        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