Forum Discussion
RubenIdx
6 years agoHelper I
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...
- Anonymous6 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
PaulDBrown
6 years agoCommunity Champion
Is the function ISINSCOPE on Power Pivot? If so, try using that instead (same syntax).
Please let us know if there is a difference (I'm curious!)
- RubenIdx6 years agoHelper I
Hi! I have reviewed and this function is not available in powerpivot. Thanks