I’ve detect that some dax code doesn’t works in PBI.
Are there some guide abut this?
I’ve detect that some dax code doesn’t works in PBI.
Are there some guide abut this?
Best answer by fwagner
Hey
that’s a very cool question!
I would suggest to create a “primary” or core tabular model in TimeXtender, then add a secondary model, with a live connection to the primary, and all the features, such as calculation groups and additional measures on top.
We described the procedure in TimeXtender Tuesdays Episode 26: Calculation Groups
For reference: these are the steps I took to test your scenario:
1. enable the Preview Feature DirectQuery for PBI data sets and AS:
2. connect to the primary PBI dataset
3. change to a DirectQuery connection:
4. select all content of the primary model
5. make sure the secondary model is in DirectQuery mode
6. architecture/lineage of the end result looks like this
With that, I created a USERCULTURE() measure, both in the primary model (in TimeXtender), and also in the secondary model in Power BI Desktop.
The secondary model respects changing user cultures, while the culture is apparently not passed down to the core/primary model, as you can see here:
Now, I would also have expected that the culture is propagated downwards, but apparently it is not.
So therefore, I would advise to built your core measures, i.e. the numerical calculations, into the primary model, within TimeXtender, and display/formatting related stuff, that changes with culture into the secondary model, built with Power BI Desktop:
Side note: the behaviour you discovered is not a limitation in TimeXtender, but a limitation in Power BI / DirectQuery on Tabular Models. Since the feature is still in Preview Mode, maybe it will be fixed by Microsoft - would be cool if it were. Searching https://ideas.powerbi.com/ideas/, I couldn’t find anything related there, yet.
I hope that helps, please let us know if the suggested way works for your situation.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.