Cant create average of a measure

[Anonymous]

I am struggling with the below.

I have a page where I am creating an imagined cost to run a vessel.

When I try and average these costs on the basis of who owns the vessel I am getting the below error message.

The Daily Cost Measure is working but I am unable to average it for each of the Owners.

Owners will have various vessels, so I need to average the Measure which calculates the cost of running that vessel.

The Error message refers to one of the measures which goes into creating the Daily Cost:

DailyBallastCons = SELECTEDVALUE('Model Vessel'[Ballast Aux])+(SELECTEDVALUE('Model Vessel'[Ballast HFO])*(SELECTEDVALUE('Ballast Speed'[Ballast Speed],12)/SELECTEDVALUE('Model Vessel'[Ballast Speed]))^'Speed Cons Factor'[Speed Cons Factor Value])*(1+SELECTEDVALUE(AgeLoss[Excess Fuel]))

Can someone suggest why I can calculate a Daily Cost for the vessels but then not average across owners?

[v-piga-msft]

Hi @Anonymous,

Based on the error message, it seem that the error should be caused by the  ^ 'Speed Cons Factor'[Speed Cons Factor Value] which is similar to the dax function POWER().

You could have a reference of this similar thread. 

If you still need help, please share a dummy pbix file which can reproduce the scenario, so that we can help further investigate on it? You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.)

Best Regards,

Cherry

[Anonymous]

Hey, thanks for your suggestions, couldnt get the solution to work. I have tried making all the referenced values abs() but still getting the same error. None of the values should be negative, the Ballast Speed is a value i have entered 1-20 and Model Vessel Ballast is 12. The Speed cons factor is between 1-3. Im sure im overlooking something but I cant see how the error message could be correct

[Anonymous]

It appears that Powerbi is timing out, when I limit the amount of data the measure starts to work. Or in the data which I am excluding there is an issue, but I cant find the issue. Is there anyway of testing if the system is timing out?

[v-piga-msft]

Hi @Anonymous,

You may could use Dax Studio to analyze your formula.

Best  Regards,

Cherry

[Anonymous]

Hi Cherry, Thanks that's a great suggestion. Just struggling to get my head round how to test the measure in DAX Studio. I understand that I should use Evaluate row("OutputColumnTitle",[Measure]) to run the measure but it isn't returning a result. I couldn't find anywhere in the documentation that would explain this.