Target Allocation by Day

Hi VeemalS ,

My Date table is as below.

Date = 
ADDCOLUMNS( CALENDAR(DATE(2022,01,01),DATE(2022,12,31)),"Year",YEAR([Date]),"Month",MONTH([Date]),"MonthName",FORMAT([Date],"MMM"))

Relationship:

Measure:

Target by Day = 
VAR _COUNT =
    COUNT ( 'Date'[Date] )
VAR _TARGET =
    CALCULATE (
        SUM ( 'Table'[Target] ),
        FILTER ( 'Table', 'Table'[Month] = MAX ( 'Date'[MonthName] ) )
    )
RETURN
    DIVIDE ( _TARGET, _COUNT )

Result is as below.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.