Apply FILTER to IF in measure

[kbbsl]

Hi All,

I have the following measure on a power bi visual but would like to apply a filter to it in the measure (rather than on visual) so that it includes months year to date starting with June 2025 (i.e. will only show June and July so far for 2025). Please could someone assist?

Total percentage =

IF(

SELECTEDVALUE(Total[Month])="Total",

CALCULATE('Briefing List'[Total percentage part 1], VALUE(FILTER(Total,Total[Month]<=MAX('Date'[Date])))),

'Briefing List'[Total percentage part 1])

Total = table of months with Total added to it so that it is displayed on graph

Total percentage part 1 = CALCULATE('Briefing List'[Completion step 1] / 'Briefing List'[Monthly count percentage] )*100

Completion step 1 = SUMX (

    VALUES ( 'Date'[Month]),

    CALCULATE ( DISTINCTCOUNT ( 'Safety Conv'[Employee Name Final] ) )

)

Monthly count percentage =

SUMX(CALCULATETABLE(VALUES('Briefing List'[Created]),ALL('Date')),

var _Endofdaterange = MAX('Date'[Date])

var _Startdate = MIN('Date'[Date])

var _numberofmonths = DATEDIFF(_Startdate,_Endofdaterange,MONTH)+1

var _Amount = CALCULATE(SUM('Briefing List'[Created]),ALL('Date'))

RETURN

(_numberofmonths*[Monthly count]))

Thanks

[kbbsl]

@bhanu_gautam Thanks for the prompt response, this works a treat.

[bhanu_gautam · Accepted solution]

@kbbsl , Try using

DAX
Total percentage =
IF(
SELECTEDVALUE(Total[Month]) = "Total",
CALCULATE(
'Briefing List'[Total percentage part 1],
FILTER(
ALL('Date'),
'Date'[Date] >= DATE(2025, 6, 1) && 'Date'[Date] <= TODAY()
)
),
'Briefing List'[Total percentage part 1]
)