topic Re: how tu sum more filtered fields in one column in DAX Commands and Tips

how tu sum more filtered fields in one column

TomaKavi — Wed, 08 Jun 2022 04:23:09 GMT

Hello guys,

is there a better way how to make a simple sum for specific fields in one Column than this below ?

SR1100 positive 3 =
CALCULATE (
    [Total Value],
    FILTER (
        Total_2021,
        Total_2021[Consolidation account] IN { "V10000", "V20000", "V30000" }
    )
)

Re: how tu sum more filtered fields in one column

v-xiaotang — Mon, 13 Jun 2022 01:52:04 GMT

Hi TomaKavi

You can choose according to your scenario. If you only need to call it once, use this method.

If you need to call it multiple times, create a table.

test = CALCULATE ( SUM(Total_2021[value]), FILTER ( Total_2021, Total_2021[Consolidation account] IN VALUES('filter'[Column1]) ) )

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

Re: how tu sum more filtered fields in one column

TomaKavi — Mon, 13 Jun 2022 11:31:32 GMT

actually not, I need this measure to be a part of another measure. I was more asking if there is another way ( a bit simple) how to nest the 3 filtered values and sum them together.

Re: how tu sum more filtered fields in one column

v-xiaotang — Thu, 30 Jun 2022 07:43:24 GMT

Hi TomaKavi

Thanks for your reply.

>> I need this measure to be a part of another measure. .... how to nest the 3 filtered values and sum them together.

The usual approach is to create a measure to calculate the total, and then create a measure to call it, for example

measure 1= sumx(filter('table', 'table '[xxx]=....),'table'[value])

measure 2= var _totalFromM1=[measure 1] var _expression=calculate(....) return _totalFromM1+_expression

This is the simplest way.

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

Re: how tu sum more filtered fields in one column

TomaKavi — Mon, 04 Jul 2022 09:37:02 GMT

and that is the poin HOW to add more values here ,,Table [xxx] =......., how do you nest more parameters there ?

measure 1= sumx(filter('table', 'table '[xxx]=....),'table'[value])

Re: how tu sum more filtered fields in one column

v-xiaotang — Thu, 07 Jul 2022 06:46:55 GMT

Hi TomaKavi

Thanks for your reply.

>> how do you nest more parameters there

You can try

measure 1= sumx(filter('table', 'table '[xxx1]=.... && 'table '[xxx2]=.... && 'table '[xxx3]=....),'table'[value])

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

Re: how tu sum more filtered fields in one column

TomaKavi — Mon, 11 Jul 2022 04:52:24 GMT

got you, but what if we are talking about the same table, I guess the solution that I have written at the top is the only one right ?