Forum Discussion

Svillanueva94's avatar
Svillanueva94
Regular Visitor
5 years ago
Solved

Calculus between 2 unrelated tables

Hi, everyone! My problem is that I want to make some math between two tables that have no relation.  The first table only contains: Column   Example Service   Processing Total cost    ...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Svillanueva94 ,

     

    Based on your description, I created two sample table and did a test. I can reproduce your issue.

    So I create a new measure as follows.

    Measure = 

    var x1=SUMX(FILTER(ALL('AA_Costos'),[Servicio]="Procesamiento"),[Pagado en Pesos SIN IVA])

    var x2=CALCULATE(SUM('Autorizaciones'[Autorizaciones]),ALL())

    var x3=x1/x2

    return

    SUMX(FILTER(ALL(Autorizaciones),[IdCliente]=SELECTEDVALUE(Autorizaciones[IdCliente])),[Autorizaciones])*x3

    Result:

    Hope that's what you were looking for.

    Best Regards,

    Yuna

     

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

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Svillanueva94 ,

 

Based on your description, I created two sample table and did a test. I can reproduce your issue.

So I create a new measure as follows.

Measure = 

var x1=SUMX(FILTER(ALL('AA_Costos'),[Servicio]="Procesamiento"),[Pagado en Pesos SIN IVA])

var x2=CALCULATE(SUM('Autorizaciones'[Autorizaciones]),ALL())

var x3=x1/x2

return

SUMX(FILTER(ALL(Autorizaciones),[IdCliente]=SELECTEDVALUE(Autorizaciones[IdCliente])),[Autorizaciones])*x3

Result:

Hope that's what you were looking for.

Best Regards,

Yuna

 

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