Show full month target in a matrix for each product when we have a page level MTD filter

[nj17]

Hi All,

I have a matrix where i have brand name and under that products.I am currently showing MTD Revenue Target and want to show Full month target in another column.

How can I show Full month target along with MTD revenue target when I have a Page level filter set to show only MTD records

currently both are same

@amitchandak 

Thanks,

NJ

[nj17]

Hi @AUDISU 

it is working for me.

but I want to know how it is ignoring page level filter? which only showing value for MTD and not whole month

[AUDISU]

Hi @nj17 ,

Which slicers do you have in your report?

Thank you.

[nj17]

Hi @AUDISU 

I have below page level filter on page where i am using Full Month Target.

MTD ia flag in date table for all MTD dates.why this filter not affecting the measure?

[AUDISU · Accepted solution]

Hi @nj17 

Please use following DAX code.

Full month target =

//Get start date of selected month

VAR SD =  STARTOFMONTH(Calender[Date])

//Get ebd date of selected month

VAR ED = ENDOFMONTH(Calender[Date])

// Calculate full month target

VAR Fullmonthtarget = CALCULATE(SUM(MyTable[Amount]),Calender[Date] >= SD && Calender[Date] <= ED)

RETURN

Fullmonthtarget

Thank you.