How to convert the following DAX expression to a scalar?
SELECTCOLUMNS(FILTER(rules, rules[RuleNumber] = 1), "AntecedentID", [AntecedentID])
This returns a table with a single cell, but I need a scalar value.
Tried wrapping the expression into a VALUES or a MAX, but no luck.
webportal , not very sure I got it. Try like
maxx(FILTER(rules, rules[RuleNumber] = 1), [AntecedentID])
or like
calculate(maxx(values([AntecedentID]), [some meausre]),FILTER(rules, rules[RuleNumber] = 1))
webportal , not very sure I got it. Try like
maxx(FILTER(rules, rules[RuleNumber] = 1), [AntecedentID])
or like
calculate(maxx(values([AntecedentID]), [some meausre]),FILTER(rules, rules[RuleNumber] = 1))
That's it, thank you so much!
