Forum Discussion

AllanBerces's avatar
AllanBerces
Icon for Post Prodigy rankPost Prodigy
10 months ago
Solved

Summarized Table with filter and two sum

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
Need Help
  • AnkitaaMishra's avatar
    AnkitaaMishra
    10 months ago

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

3 Replies

  • AnkitaaMishra's avatar
    AnkitaaMishra
    Icon for Super User rankSuper User
    10 months ago

    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