Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Proud to be a Super User!
Solved! Go to 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.
Proud to be a Super User!
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
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
Proud to be a Super User!
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
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.
Proud to be a Super User!
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
100 | |
80 | |
63 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |