Forum Discussion
Performance Analyzer DAX Query run through Power Automate returns error: More than 1 result...
There are 2 EVALUATE statements, the first one is returning the values without the grand total and the second one is returning everything including the grand total. Decide which one you want in your power flow and delete the other EVALUATE statement
Delete everything from the first EVALUATE to the end and replace it with
EVALUATE __DS0PrimaryShowAll ORDER BY [IsGrandTotalRowTotal] DESC, [v0_Grand_Total] DESC, 'Students'[Firstname], 'Students'[LASTNAME], 'Students'[Year], 'Students'[HC]
There are 2 EVALUATE statements, the first one is returning the values without the grand total and the second one is returning everything including the grand total. Decide which one you want in your power flow and delete the other EVALUATE statement
Thank you, johnt75.
Is there a way to combine them - get the values with the grand total and everything else - into the first evaluate?
As a test, I tried to get rid of the TopN (as per ruthpozuelo's video) and second evaluate (second evaluate just got the output of the TopN) and I received an error:
"Query (70, 3) Column 'IsGrandTotalRowTotal' cannot be found or may not be used in this expression."
Delete everything from the first EVALUATE to the end and replace it with
EVALUATE __DS0PrimaryShowAll ORDER BY [IsGrandTotalRowTotal] DESC, [v0_Grand_Total] DESC, 'Students'[Firstname], 'Students'[LASTNAME], 'Students'[Year], 'Students'[HC]I tried that, but the result wasn't correct - I am missing most columns.
[I deleted the evaluate sections as described.]
[Output]
Try running it in DAX Studio or Tabular Editor and see what that outputs