Summarized Table with filter and two sum

[AllanBerces]

Hi good day can any one help me correct my summarized table, it shows error when i used below.

SummarizedPMainData = FILTER(

SUMMARIZE('MAIN_DATA',

'MAIN_DATA'[FabJobcarding] ,

'MAIN_DATA'[Main Cat.] ,

"Fab_Estimate", CALCULATE(SUM('MAIN_DATA'[Estimated hours]),

"Fab_Remaining", CALCULATE(SUM(MAIN_DATA[Remaining hours])))),

[Main Cat.] = "Fab")

Thank you

[AnkitaaMishra]

Hi @AllanBerces , can you try below DAX :
SummarizedPMainData =
VAR _FabData =
FILTER('MAIN_DATA', 'MAIN_DATA'[Main Cat.] = "Fab")
VAR _Summarize =
SUMMARIZE(
_FabData,
'MAIN_DATA'[FabJobcarding],
'MAIN_DATA'[Main Cat.],
"Fab_Estimate", SUM('MAIN_DATA'[Estimated hours]),
"Fab_Remaining", SUM('MAIN_DATA'[Remaining hours])
)
RETURN
_Summarize

[AllanBerces]

@AnkitaaMishra thank you very much working as i need

[AnkitaaMishra · Accepted solution]

Hi @AllanBerces Glad I could help!
Could you please mark the previous message as "Accepted as Solution" so the thread can be closed?