Repeat value of min date

[freginier]

Hi 

I have a table like this 

Date	Ticket	KPI	Type	Value
01/01/2020	TICK01	KPI01	Recurring	10
01/02/2020	TICK01	KPI01	Recurring	8
01/02/2020	TICK01	KPI02	No Recurring	7
01/03/2020	TICK01	KPI02	No Recurring	6
01/03/2020	TICK02	KPI03	Recurring	12
01/04/2020	TICK02	KPI03	Recurring	13

I have a slicer to select month and year and I select multiple month.

I would like to have a measure that repeat the sum of the min month on each row. For example if I select February & 2020 I should have 15 on all rows (selected).

How can I do this ? 

[Ashish_Mathur · Accepted solution]

Hi,

You may download my PBI file from here.

Hope this helps.

[ryan_mayu]

@freginier 

you can try this

Measure 2 = 
var _mindate=min('Table 2'[Date])
var _minmonth=month(_mindate)
var _minyear=year(_mindate)
return sumx(FILTER(ALL('Table'),year('Table'[Date])=_minyear&&month('Table'[Date])=_minmonth),[measure])

don't create relationship between fact table and date table.

pls see the attachment below

[ManguilibeKAO]

Hi freginier,

Could you show the output you want?

Best regards.