Apply FILTER to IF in measure

kbbsl — Wed, 30 Jul 2025 11:42:26 GMT

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

Re: Apply FILTER to IF in measure

bhanu_gautam — Wed, 30 Jul 2025 11:45:30 GMT

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]
)

Re: Apply FILTER to IF in measure

kbbsl — Wed, 30 Jul 2025 12:42:22 GMT

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

topic Re: Apply FILTER to IF in measure in DAX Commands and Tips

Apply FILTER to IF in measure

Re: Apply FILTER to IF in measure

Re: Apply FILTER to IF in measure