Forum Discussion
Solved
Performance Analyzer DAX Query run through Power Automate returns error: More than 1 result...
Hello everyone, I am running the Power Automate action "Run a query against a dataset" with the advice from the Blog (and fourmoo and Curbal). I copied the DAX Query from the Performance ana...
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]
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