topic Re: Add fixed value to variable values in DAX Commands and Tips

Add fixed value to variable values

amgelain — Mon, 23 Oct 2023 17:28:11 GMT

Hello,

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

Thank you in advance for your help.

amgelain

Re: Add fixed value to variable values

Jihwan_Kim — Mon, 23 Oct 2023 17:45:22 GMT

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.

Re: Add fixed value to variable values

amgelain — Mon, 23 Oct 2023 22:21:24 GMT

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

Re: Add fixed value to variable values

amgelain — Mon, 23 Oct 2023 22:24:57 GMT

Re: Add fixed value to variable values

Jihwan_Kim — Tue, 24 Oct 2023 03:54:31 GMT

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.

Re: Add fixed value to variable values

amgelain — Tue, 24 Oct 2023 22:44:01 GMT

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