topic SUMMARIZE DAX formula help in DAX Commands and Tips

SUMMARIZE DAX formula help

MarcoMizz — Fri, 30 Jun 2023 12:27:09 GMT

Hi Everyone

I have this DAX formula in order to create one new Table:

SUMMARIZE(fFLX,fFLX[CategoriaBDG],fFLX[G/L],fFLX[Period], "QTY", SUM(fFLX[Quantity]))

could you please help me in case I would like to have the SUM just for few [CategoriaBDG] value? How I need to change the DAX expressione below?

regards

marco

Re: SUMMARIZE DAX formula help

tamerj1 — Fri, 30 Jun 2023 12:53:30 GMT

Hi MarcoMizz
Something like this

= SUMMARIZE ( FILTER ( fFLX, fFLX[CategoriaBDG] IN { "Value1", "Value2", "Value3" } ), fFLX[CategoriaBDG], fFLX[G/L], fFLX[Period], "QTY", SUM ( fFLX[Quantity] ) )

Re: SUMMARIZE DAX formula help

ThxAlot — Fri, 30 Jun 2023 15:26:24 GMT

= CALCULATETABLE( SUMMARIZECOLUMNS( fFLX[CategoriaBDG], fFLX[G/L], fFLX[Period], "QTY", SUM( fFLX[Quantity] ) ), fFLX[G/L] IN { 1, 2, 3 } )

Re: SUMMARIZE DAX formula help

MarcoMizz — Sat, 01 Jul 2023 05:13:58 GMT

Thanks for the support!