Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Define Measures in combination with Calculation Group format strings #1154

Closed
burtbinia91 opened this issue Jul 24, 2023 · 2 comments
Closed
Labels

Comments

@burtbinia91
Copy link

Describe the bug
I have been working with calculation groups a lot lately and noticed that im unable to define measures in Dax Studio after introducing format string expressions in one of my calculation groups.

I understand that when introducing format string expressions a hidden measure is created in the model for each measure. So far this has not been a problem. Not beeing able to define the measures anymore in Dax Studio is though.

I have tested this the following way:

  • I introduced several CG's inculding one with a format string expressions on our DEV environment and introduced all other CG but the format ones in our Test environment aswell. In Test im able to define the measures while can not on Dev. Then I removed all the format string ones on Dev and re-deployed the model and voila I can then define the measures again.

I am always able to "define and expand" measures but not just "define" without opening any lower levels. This makes me think this could be a bug.

To Reproduce
Steps to reproduce the behavior:

  1. Introduce CG with format string logic to model
  2. Try to define measure in Dax Studio
  3. It only opens the measure name with an "=" but no formula

Expected behavior
When defining a measure it should be possible to see the formula

Screenshots
If applicable, add screenshots to help explain your problem.

Additional context
We are running DAX Studio 3.0.8

@github-actions github-actions bot added the triage issues that need to be classified label Jul 24, 2023
@marcosqlbi marcosqlbi added bug and removed triage issues that need to be classified labels Jul 24, 2023
@marcosqlbi
Copy link
Contributor

Great bug description!
The DEFINE MEASURE features (all variations) didn't work if a model have calculation groups that define custom format string AND the model didn't use the dynamic format string on any measure. It was a regression introduced by the new code that manages the dynamic format string defined in measures.
I was able to reproduce the bug and fix the code. Version 3.0.9 will publish the but, if you need a pre-release you can get the latest build here:
https://ci.appveyor.com/project/DarrenGosbell/daxstudio/build/artifacts

The issue will be automatically closed once the 3.0.9 version is published.

@burtbinia91
Copy link
Author

Wow, thank you very much for the fast reply and fix. Much appreciated!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

2 participants