How to ignore column context in calculate dax measure

[PradeepDive]

Hi,

I have three tables as below

1)  Calenader =  Simple Calendar table with dates

2)  ResourceTime = This table has resource time details by date  with details like [Resource ID], [Trans Date]  and [Hours]

3)  Resource Target = This table has resource targets with details like [Resource ID] and [Target] 

Relationship between table is   

[Calender]  1             ---->  * [ResourceTime]  on Date

[Resource Target] 1  ---->  * [ResourceTime]  on Resource ID

In table format it is like below

Resource ID	Trans Date	Hours
10001	01/01/21	8
10001	01/15/21	8
10001	03/02/21	5
10003	03/15/21	2

Resource ID	Target
10001	35%
10002	25%
10003	62%

I am trying to create a matrix table where the row has resource ID from Resource Time and Target from Resource Target as value

Column is from Calendar table as Month which gives me something like below

	JAN	Feb	Mar	Apr
10001	35%		35%
10003			62%

Its showing me Targets only for months where Hours table has some hour.  I want it to shows it for all the months irrespective hours table has hours or not.

I am using a measure like below 

Resource Target =  

  Var target = selectedvalue(ResourceTime[Resource ID])

Return

  Calculate ( Max(Resource Target[Target]), 

       Filter(Resource Target, Resource Target[Resource ID] = target) ) 

Is there a way the measure can ignore date context and give me target for all months.

Thanks in advance.

[v-stephen-msft · Accepted solution]

Hi @PradeepDive ,

This is the desired result you want.

Measure =
CALCULATE (
    SUM ( 'Resource Target'[ Target] ),
    ALLEXCEPT ( 'Resource Target', 'Resource Target'[Resource ID] )
)

Best Regards,

Stephen Tao

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