Forum Discussion
how to use filter with summarize function
Hi, I want to create dax expressionon below sql: select sum(business_duration), 'Task SLA'[task], 'Task SLA'[has_breached], 'Task SLA'[sla] from task_sla where task_sla.task = child.number grou...
amitchandak
Super User
Super UserAnonymous , You can use
filter(Crossjoin(Table1,table2),table1[a]=table2[a])
but this is very costly
refer these are few options here
https://www.sqlbi.com/articles/from-sql-to-dax-joining-tables/
also like
summarize(filter(Table1,Table1[a] = max(Table2[a])),Table1[id],Table1[a],"Measure1",[measure]....)
Hi,
I have used the below DAX:
Child Task SLA2 =
SUMMARIZE(
filter('Task SLA', 'Parent'[number] = Max('Task SLA'[task])),
'Task SLA'[task],
'Task SLA'[has_breached],
'Task SLA'[sla],
'Task SLA'[Child Task],
'Task SLA'[Duration Bucket],
"Business Duration", SUM('Task SLA'[Business Duration Days])
)
but I am facing the below error message:
A table of multiple values was supplied where a single value was expected.
any help on this?