Add fixed value to variable values

[amgelain]

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 · Accepted solution]

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]

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]

[Jihwan_Kim]

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.

[amgelain]

Hello,

Your help was very important in clarifying my doubt. I made a small adjustment to the table relationships and it worked.

Thank you very much @Jihwan_Kim