Forum Discussion
Solved
Convert DAX expression table into a scalar
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 s...
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))