measure that was working now has a red line and fails

[vanessafvg]

i have this measure which i built on the same version of power bi yesterday but on a different computer, when i opened it up this morning this measure, which only fails when you click into it.

TotalDefects = if(ISBLANK(COUNTA(Defects[Key])),0,COUNTA(Defects[Key]))

it works completely fine until i actually go into the measure then the last part of the if statment for false, has a red line under it and it fails and breaks the model.

This is a bit annoying, any ideas?

[v-yulgu-msft]

Hi @vanessafvg,

What is the error prompt when you go into this measure? What is the error message when you add this measure into visual?

Please pay attention to the column name referenced in this measure, check whether it indeed existis in current .pbix file. For furthur analysis, please share some sample data and the report definition.

Best regards,
Yuliana Gu

[vanessafvg]

there is not error as such, i have a feeling it has to do with regional or such settings, opening up the same model on a different computer shows no issues

[v-yulgu-msft]

Hi @vanessafvg,

On the different computer as you mentioned above, please create a new .pbix file and use the same formula, especially the COUNTA part in this file to check whether issue persists?

Regards,
Yuliana Gu

[vanessafvg · Accepted solution]

i had my regional settings on English South AFrica, ive changed it to English United Kingdom which is what the other computer is on and that seems to have resolved the issue.

[spuder]

Hi,

are you using Power BI Desktop or Powerpivot in Excel.

I sometimes have the problem that in Powerpivot I got some errors using the wrong delimiter in the Measure. 

When I write a measure directly (right click on the table name->new measure) then I have to use the "," and when i go to the powerpivot ribbon and use Measure then I must use the ";" as delimiter.

Maybe this is it. Is there no error message when you try to fire up the measure?