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.

     

     

     

     

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]))

    • amgelain's avatar
      amgelain
      Regular Visitor
      2 years ago

      • Jihwan_Kim's avatar
        Jihwan_Kim
        Super User
        2 years ago

        Hi,

        Thank you for your message.

        I am not sure what is your expected outcome, and how the fact table looks like, but I guess the definition of fixed number granularity is monthly level? 

        If the fact table shows daily granularity, but the definition of fixed number is monthly level, then the formula need to be written in a different way.

        Thank you.