Cost / Value Transported Indicator

[Anonymous]

Hello, PBI community! Need help.
Need Help

Goal:
My objective is to make a division to obtain a 'Cost / R$ Transported' indicator always from my 'last period' or 'month to month' or 'daily'.

However, my 'Numerator' is a fixed monthly data ('DRE' [ORÇAMENTO]) from the query 'DRE' and my 'Denominator' is a data that varies daily ('fsg3342' [VLR MERC]).
'DRE' ORÇAMENTO'fsg3342' VLR MERC

Problem:
I have only one release per month on 'DRE' [ORÇAMENTO] and several releases within a day on 'fsg' [VLR MERC].

What I managed to think, but still doesn't answer me:
Custo/R$ Transportado = CALCULATE(
DIVIDE(
SUM('DRE'[ORÇADO]),SUM('fsg3342'[VLR MERC]),0)
)

Could anyone help me?
Ty

[v-jingzhang · Accepted solution]

Hi @Anonymous 

Have you created relationships between tables? I suggest linking both tables to Calendar table and then the measure will work. You may download the PBIX file.

Kindly let me know if this helps.

Community Support Team _ Jing Zhang
If this post helps, please consider Accept it as the solution to help other members find it.