Create measure to sum a group with numeric 1,2,3

[Anonymous]

Do anyone know how to create a measure so that it is the sum of male including option 1, 2, 3, my expected outcome is 109+140+30=279?

[MahyarTF]

Hi,

Do you want to have a Card as shown the sum of the Number for Male and 1,2,3 ?

If yes, you could use the below code to create the measure :

MaleCnt = CALCULATE(sum(Sheet114[Count]),

 ALLSELECTED(Sheet114[Sex]),

And(Sheet114[Sex] = "Male" , Sheet114[Num] in {1,2,3})

                )

thanks for your Kudos and please mark it as a solution if it helps.

[Jihwan_Kim]

Hi,

I am not sure how your datamodel looks like, but I tried to create a sample pbix file like below.

Please check the below picture and the attached pbix file.

I hope the below can provide some ideas on how to create a solution for your datamodel.

Value sum: = 
SUM( Data[Value] )

Expected value sum: =
CALCULATE (
    [Value sum:],
    KEEPFILTERS ( Gender[Gender] = "Male" ),
    KEEPFILTERS ( 'Group'[Group] IN { 1, 2, 3 } )
)