Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

If Statement Aggregation

Hi,    I wrote a measure to calculate job costs utilizing different accounting methods based on time intelligence. My example code is below: Estimated Final Cost = VAR CurrentDate = TODAY() VAR...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Anonymous ,

Could you please provide some sample data and the formulas of measures applied in measure "Estimated Final Cost" just as suggested by lbendlin in order to make troubleshooting? Also please provide the correct results which should display on visual.

In addition, please try to create a new measure as below to replace the measure "Estimated Final Cost" on the visual and check if it can return the correct values...

Measure = SUMX ( VALUES ( 'MDM WELL'[Formation] ), [Estimated Final Cost] )

Best Regards

Rena

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Anonymous 

 

That measure didn't provide a different answer. It definitely looks like it is evaluating the date logic using the minimum returned valued from the children.

 

I can try and provide some sample data though. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Anonymous ,

    Thanks for your reply. Could you please provide some sample data for the following tables and existed relationships among them? It is better if you can provide your sample pbix file(exclude sensitive data). Thank you.

    vwSpotfire_CAPEX

    Expense Classification Bridge

    AFE_Budget_All

    vwSpotfire_CAPEX_Estimated_Expense

    MDM WELL

    Best Regards

    Rena