Forum Discussion

amgelain's avatar
amgelain
Regular Visitor
2 years ago
Solved

Add fixed value to variable values

Hello,

 

I need to add the fixed values per company to the variable values per company.

 

Thank you in advance for your help.

 

amgelain 

  • Jihwan_Kim's avatar
    Jihwan_Kim
    2 years ago

    Hi,

    I am not sure if I understood your question correctly, but I tried to create a sample pbix file like below.

    Please check the below picture and the attached pbix file.

     

     

     

     

5 Replies

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Super User
    2 years ago

    Hi,

    I am not sure if I understood your question correctly, but I tried to create a sample pbix file like below.

    Please check the below picture and the attached pbix file.

     

     

     

     

    • amgelain's avatar
      amgelain
      Regular Visitor
      2 years ago

      Hello,

      I applied RELATED, made the relationships between the tables, however it is generating a value that is very different from what it should be. Would there be any other adjustments to the formula?

      Thanks.

       
      Total de Admissões = SUMX(FILTER(AdmDem, AdmDem[Tipo] = "Admissões"), AdmDem[Quantidade]+RELATED(Saldos[Quantidade]))