Summarizing columns and measures - Power Automate

[srigag900]

Hi All,

I have the following power automate scrip which really hard to fix. Im out of options. Can anyone help me out in this regard?

DEFINE
VAR TotalFundsOpenInEagle =
IF(
ISBLANK(
CALCULATE(
COUNTA('FundDashboard'[Id]),
FILTER('FundDashboard', 'FundDashboard'[ReadyForProcess] = FALSE)
)
),
0,
CALCULATE(
COUNTA('FundDashboard'[Id]),
FILTER('FundDashboard', 'FundDashboard'[ReadyForProcess] = FALSE)
)
)

VAR TotalFundsCloseInEagle =
IF(
ISBLANK(
CALCULATE(
COUNTA('FundDashboard'[Id]),
FILTER('FundDashboard', 'FundDashboard'[ReadyForProcess] = TRUE)
)
),
0,
CALCULATE(
COUNTA('FundDashboard'[Id]),
FILTER('FundDashboard', 'FundDashboard'[ReadyForProcess] = TRUE)
)
)

EVALUATE

SUMMARIZE (
SELECTCOLUMNS (
'FundDashboard'[FundId],
'FundDashboard'[EntityName],
'FundDashboard'[CurrentStatus],
'FundDashboard'[ReadyForProcess]),
TotalFundsCloseInEagle,
TotalFundsOpenInEagle
)

[v-yifanw-msft]

Thank you @Alex87 for your prompt reply.

Hi @Alex87  ,
May I ask if you have tried the suggestions above? If the suggestion helped you, you might consider marking it as a solution. If the problem has not yet been solved, please feel free to ask us a question.

Best Regards,

Ada Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Alex87]

The error might come from Summarize(Selectcolumns. and from the last two variables.

try if this works better

DEFINE
VAR TotalFundsOpenInEagle =
CALCULATE(
COUNTA('FundDashboard'[Id]),
'FundDashboard'[ReadyForProcess] = FALSE
)

VAR TotalFundsCloseInEagle =
CALCULATE(
COUNTA('FundDashboard'[Id]),
'FundDashboard'[ReadyForProcess] = TRUE
)

EVALUATE
SUMMARIZE (
'FundDashboard',
'FundDashboard'[FundId],
'FundDashboard'[EntityName],
'FundDashboard'[CurrentStatus],
'FundDashboard'[ReadyForProcess],
"Total Funds Closed", TotalFundsCloseInEagle,
"Total Funds Open", TotalFundsOpenInEagle
)