cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Reply
Selwynster
Helper II
Helper II

Referencing a field from a query in Measures Folder

 
4 REPLIES 4
johnyip
Super User
Super User

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.



Please mark my post as the solution if this answers your question!
Appreciate your Kudos !!

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
Community Support
Community Support

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.

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

Helpful resources

Announcements
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors