Forum Discussion

benfedit's avatar
benfedit
Icon for Advocate I rankAdvocate I
5 years ago
Solved

New composite model - DAX help - calculation cost * countrows()

hi all,   I'm using the new feature "direct query for power bi and azure analysis services". My data sources are as follows:   Fact table (800M rows) (azure analyisis services)  -Excel_Key (Cal...
Need Help
  • benfedit's avatar
    benfedit
    5 years ago


    Hi  Amitchandak,

     

    Thanks for the suggestion.

    So I seem to have found the "solution" which is more like a work around but doesn't really matter as the whole project is already a workaround 🙂

     

    So it seems that with the new composite model sumx works fine only and only when you don't put columns from the dim into the visual.

    As soon as you add any columns of the dim into the visual with the sumx measure it throws an error "An unexpected error occurred (file 'xldqas.cpp', line 510, function 'DAXDefManager-..."

     

    I gess Microsoft will fix it at some point we're only about a month since the release of this new massive feature so can't complain at all 🙂

Anonymous's avatar
Anonymous
Not applicable
5 years ago

I am having the same issue and error. Composite model (Power BI Dataset Direct Query + Other Tables Import)


If I open up DAX STUDIO the measure runs fine but for whatever reason, the Visual in Power BI Desktop cannot display.



  • benfedit's avatar
    benfedit
    Icon for Advocate I rankAdvocate I
    5 years ago

    Hi Jake,

     

    So I'm not alone in having this issue...

    The only workaround that seems to work so far at least for me and Nexter is to make sure that you do not bring the column from the import table into your visual and that should do the trick.

    I'm sure that it willget fixed soon but for now we have to take this into consideration while designing our models and using the new composite feature.