Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Measure sum

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 retent...
Need Help
v-eachen-msft's avatar
v-eachen-msft
Community Support
6 years ago

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 )