semi additive measure

[Anonymous]

I've a table Fact Performance Indicators

salesorderid	Activity_Inter_Id	date	amount	customer	Coex
111	20	03/06/2022	200	JJJ	0,3
22	60	03/07/2022	900	HHHH	0,4
33	40	03/06/2022	1200	JJJHH	0,7
34	20	03/06/2022	7200	JJJJJ	0,3

For the same year and activity_inter_id, I've the same value for Coex

Here's the data model

In the report, I've two calendars and I've two measures

CoEx calendar 1 =

               calculate(

                            if( SUMx('Fact Performance Indicators','Fact Performance Indicators'[COEX])=0 , blank(), SUMx('Fact Performance Indicators','Fact Performance Indicators'[COEX])),

                           'Date'[Mois]=max('Date'[Mois])

                        )

CoEx  Calendar 2 =

        CALCULATE(   (

                  'Fact Performance Indicators'[CoEx 1]),

                   // REMOVEFILTERS('Date'),

                     REMOVEFILTERS('YTD Calendar'),

                     USERELATIONSHIP('Date 2'[Date],'Fact Performance Indicators'[Date]) , 'Date'[Mois]=max('Date 2'[Mois])

                       )

The results are wrong: the coex is a value between 0 and 1 and it should not be count or summarize, here the results for calendar 2 are too much and more than 1 

Coex is a semi additaive value 

[v-yiruan-msft]

Hi @Anonymous ,

What's the expected result for [CoEx calendar 1] and [CoEx  Calendar 2]? Could you please explain their backend calcuation logic with some sample data and special examples? It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

How to upload PBI in Community

Best Regards