Measure sum

[Anonymous]

I want to creat a new Measure for a table which should show the total retention in the total row of the table. Can someone help me? 

In this layout the new measure should be add next to retention and show the total retention that the customer has.

https://drive.google.com/file/d/1k10VsQ2r3H_-L-3T2k0An9NajyoS0V0z/view?usp=sharing

[v-eachen-msft]

Hi @Anonymous ,

You could try the following measure:

Retention =
VAR a =
    IF (
        [Retention condition 1] >= 1
            || [Retention Condition 2] >= 1
            || [Retention Condition 3] >= 1,
        1,
        0
    )
VAR b =
    COUNTX ( VALUES ( dCalendar[YEAR] ), a )
RETURN
    IF ( ISINSCOPE ( dCalendar[YEAR] ), a, b )

[mahoneypat]

Please try this expression, substituting your actual table and column names

NewMeasure = SUMX(VALUES('Date'[Year]), [Retention])

This should give you the correct result in both your rows and total.

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat

[Anonymous]

I use this function

Retention Count = SUMX(VALUES('Purchases'[Customer]),[Retention])

and it worked but seems like it doesn't count all rentention.

As you can see year 2015 and 2016 there is retention but on retention count it doesn't.

Is there a way to fix?