Forum Discussion

RubenIdx's avatar
RubenIdx
Helper I
6 years ago
Solved

Optimizing Hasonevalue()

Hi Everybody, I want to know if is it possible to optimize Hasonevalue() in powerpivot I've created a model that runs some slowly and this is one of the principal reasons, I use many verifications Ha...
  • Anonymous's avatar
    Anonymous
    6 years ago

    HI RubenIdx,

    According to your formula, it seems like you nested other formulas in the current measure. Did you nested an iterator function? Can you please share formulas that you used to help us clarify your scenario?

    Optimizing nested iterators in DAX 

    In addition, dax functions in excel are different from power bi dax function, it will be help if you share some dummy data to test.

    How to Get Your Question Answered Quickly  

    Regards,

    Xiaoxin Sheng