Total of a Choice in the column using measure.

[mohammedkhan]

Good Day! 

I am trying to get the total number of the Married  and then like wise i want to get the total for every choice such as Married, Singles so on and so forth using measure so then i can resuse this information.

I have used mention below DAX and it did not work

Total Married Category = CALCULATE(SUMX('MARITAL_STATUS_BY_AGE (2)',

'MARITAL_STATUS_BY_AGE (2)'[15-19] = "Married" +

'MARITAL_STATUS_BY_AGE (2)'[20-24] = "Married" +

'MARITAL_STATUS_BY_AGE (2)'[25-29] = "Married"+

'MARITAL_STATUS_BY_AGE (2)'[30-34] = "Married"+

'MARITAL_STATUS_BY_AGE (2)'[35-39] = "Married"+

'MARITAL_STATUS_BY_AGE (2)'[40-44] = "Married"+

'MARITAL_STATUS_BY_AGE (2)'[50-54] = "Married"+

'MARITAL_STATUS_BY_AGE (2)'[55-59] = "Married"+

'MARITAL_STATUS_BY_AGE (2)'[60-64] = "Married"+

'MARITAL_STATUS_BY_AGE (2)'[65] = "Married"))

But when i put the total marriages into the table it worked.

Total Marriages = CALCULATE(SUMX('MARITAL_STATUS_BY_AGE (2)',

'MARITAL_STATUS_BY_AGE (2)'[15-19] +

'MARITAL_STATUS_BY_AGE (2)'[20-24] +

'MARITAL_STATUS_BY_AGE (2)'[25-29] +

'MARITAL_STATUS_BY_AGE (2)'[30-34] +

'MARITAL_STATUS_BY_AGE (2)'[35-39] +

'MARITAL_STATUS_BY_AGE (2)'[40-44] +

'MARITAL_STATUS_BY_AGE (2)'[50-54] +

'MARITAL_STATUS_BY_AGE (2)'[55-59] +

'MARITAL_STATUS_BY_AGE (2)'[60-64] +

'MARITAL_STATUS_BY_AGE (2)'[65]))

FieldsVisulization

P.S. I can get the same result from the slicer also but i would like to know why the error The cardinality is Many to many

[v-cherch-msft · Accepted solution]

Hi @mohammedkhan 

You may try below measure.

Total Marriages =
CALCULATE (
    SUMX (
        FILTER (
            'MARITAL_STATUS_BY_AGE (2)',
            'MARITAL_STATUS_BY_AGE (2)'[Marital Status] = "Married"
        ),
        'MARITAL_STATUS_BY_AGE (2)'[15-19] + 'MARITAL_STATUS_BY_AGE (2)'[20-24] + 'MARITAL_STATUS_BY_AGE (2)'[25-29] + 'MARITAL_STATUS_BY_AGE (2)'[30-34] + 'MARITAL_STATUS_BY_AGE (2)'[35-39] + 'MARITAL_STATUS_BY_AGE (2)'[40-44] + 'MARITAL_STATUS_BY_AGE (2)'[50-54] + 'MARITAL_STATUS_BY_AGE (2)'[55-59] + 'MARITAL_STATUS_BY_AGE (2)'[60-64] + 'MARITAL_STATUS_BY_AGE (2)'[65]
    )
)

Regards,

[mohammedkhan]

Thank you this is a big help

[Greg_Deckler]

What does the See Details say?