Referencing a field from a query in Measures Folder

[johnyip]

To answer your question, you may need to provide the relationship of different tables in your data.

By guessing, your DAX is calculating all the entries of [Forecasted Amount] in the 'Fact Exposure' table, becasue there is no relationship between 'Fact Exposure' and the other table.

[Selwynster]

So, there is only one table. But i am referencing it from another Folder i created, and i am creating a new Measure within that folder. Hope this makes sense?

[v-jingzhang]

Hi @Selwynster 

If you want to reference a measure in another measure, you can use it directly. If Forecasted Amount is a measure, Forecast Premium could be 

Forecast Premium =
VAR vForecastPremiumGuaranteeAmount = [Forecasted Amount]
RETURN
    IF (
        NOT ISBLANK ( vForecastPremiumGuaranteeAmount ),
        vForecastPremiumGuaranteeAmount
    )

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[Selwynster]

Thank you. 'Forecasted Amount' is from another table so i cannot reference it directly.
Error: "Cannot find Name '[Forecasted Amount]')