Forum Discussion

bhalicki's avatar
bhalicki
Helper V
9 months ago
Solved

DAX UDFs / Shared Semantic Model

Hi all,   I rely heavily on shared semantic models as a way to reduce development effort (often have one model with 20 or so reports connected).   Is there a way to create a DAX user defined fun...
Need Help
  • GeraldGEmerick's avatar
    GeraldGEmerick
    9 months ago

    bhalicki In my testing, UDF's do not work like measures in that they are not available when Live connected to the model. I have tested this and I cannot seem to see any defined UDF functions in the Live connected semantic model. I do not have any kind of local model either. 

Ahmed-Elfeel's avatar
Ahmed-Elfeel
Super User
9 months ago

Hi GeraldGEmerick,

Are you sure that UDFs is in your report?

 

  1. First you should verify UDF is actually in your model:
    • Open semantic model → Model view → Check Model explorer for "Functions" folder
    • If not there you did not save it to the model properly
  2. Try using UDF manually (even if invisible):
-- Type this exactly do not wait for IntelliSense

Test Measure = YourUDFName([Measure1], [Measure2])

 

Check preview features:

  • Both model AND report Power BI need DAX UDFs preview enabled

  • Restart after enabling

Also here is some resources you can check:

GeraldGEmerick's avatar
GeraldGEmerick
Super User
9 months ago

Ahmed-Elfeel The UDF is in the report. Connected Live, the UDF functions do not show up in DAX Query View. Also, Intellisense does not "see" the functions. This is all in Power BI Desktop. That said, the UDFs are apparently useable but not sure how anyone would know that.