New measure to combine two calculations

[Anonymous]

Hi All,

I would like to comibine the following two mesures (Average / SUM) based on county:

IF 

data_merged[crashid]="LEA"

then

crashdeathcount_agg = SUMX(DISTINCT(data_merged[crashid]),CALCULATE(AVERAGE(data_merged[crashdeathcount])))

else 

crashdeathcount_agg = SUMX(DISTINCT(data_merged[crashid]),CALCULATE(SUM(data_merged[crashdeathcount])))

Any suggestions?

Thanks in advance!

Joan

[Ashish_Mathur]

Hi,

Drag CrashID to the row labels of your Table visual and write this measure

=IF(HASONEVALUE(data_merged[crashid]),IF(VALUES(data_merged[crashid])="LEA",SUMX(DISTINCT(data_merged[crashid]),CALCULATE(AVERAGE(data_merged[crashdeathcount]))),SUMX(DISTINCT(data_merged[crashid]),CALCULATE(SUM(data_merged[crashdeathcount])))),BLANK())

Hope this helps.

[MFelix · Accepted solution]

Hi @Anonymous ,

If you already have the two measure calculated you just need to do the following code:

IF (SELECTEDVALUE(data_merged[crashid])="LEA" , crashdeathcount_agg , crashdeathcount_agg )

If you don't have the measures separated you should do:3

Measure =
IF (
    data_merged[crashid] = "LEA",
    crashdeathcount_agg
        = SUMX (
            DISTINCT ( data_merged[crashid] ),
            CALCULATE ( AVERAGE ( data_merged[crashdeathcount] ) )
        ),
    crashdeathcount_agg
        = SUMX (
            DISTINCT ( data_merged[crashid] ),
            CALCULATE ( SUM ( data_merged[crashdeathcount] ) )
        )
)

Without any data and specif details on your data model is difficult to give you a better answer.

If this doesn't wqork can you share a sample data and expected result.

Regards,

MFelix