Forum Discussion
AllanBerces
Post Prodigy
Post ProdigySummarized 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'[Ma...
Hi AllanBerces Glad I could help!
Could you please mark the previous message as "Accepted as Solution" so the thread can be closed?
AnkitaaMishra
Super User
Super UserHi 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
AllanBercesPost Prodigy
Post ProdigyAnkitaaMishra thank you very much working as i need
- AnkitaaMishra
Hi AllanBerces Glad I could help!
Could you please mark the previous message as "Accepted as Solution" so the thread can be closed?