How to avoid the data to be duplicated in line chart

[Anonymous]

Hello everyone,

I am trying to do show the signings vs the target (calendarized) but we do not have yet the signings data from may to december 2021. 

How can I do to avoid the data to show "92" from may to december ? 

Here are my 2 measures :

Signings Cumulated = CALCULATE(SUM('Opp Table'[Premium €]),'Opp Table'[Negotiation Status]="7-Won",'Opp Table'[Status Signings Date (Year)]=2021,

FILTER(ALL('Calendar'),

'Calendar'[KeyDate]<= MAX('Calendar'[KeyDate])))

Target Full Year = CALCULATE(SUM(Targets Table[Target NB Calendarized (K€)]),'Calendar'[KeyYear]=2021,

FILTER(ALL('Calendar'),

'Calendar'[KeyDate]<= MAX('Calendar'[KeyDate])))

Thank you. 

[v-luwang-msft · Accepted solution]

Hi @Anonymous ,

Since there is no your actual data, so I built a model myself, you can refer to it, I hope it can bring you help.

Base data:

then use the following measure:

actsum =
VAR test1 =
    CALCULATE (
        SUM ( 'Table'[act] ),
        FILTER ( ALL ( 'Table' ), 'Table'[month] <= MAX ( 'Table'[month] ) )
    )
VAR test2 =
    CALCULATE (
        MIN ( 'Table'[month] ),
        FILTER ( ALL ( 'Table' ), 'Table'[act] = BLANK () )
    )
VAR test3 =
    IF ( MAX ( 'Table'[month] ) < test2, test1, BLANK () )
RETURN
    test3

taract = CALCULATE(SUM('Table'[tar]),FILTER(ALL('Table'),'Table'[month]<=MAX('Table'[month])))

And final get the below:

You could download my pbix file if you need.

Best Regards

Lucien

[amitchandak]

@Anonymous , Try measure like

Signings Cumulated =
var _1 = maxx(allselected('Calendar'),'Calendar'[KeyDate])
return
CALCULATE(SUM('Opp Table'[Premium €]),'Opp Table'[Negotiation Status]="7-Won",'Opp Table'[Status Signings Date (Year)]=2021,
FILTER(ALL('Calendar'),
'Calendar'[KeyDate]<= MAX('Calendar'[KeyDate]) && 'Calendar'[KeyDate] <= _1))