Sum based on Date filter for each ID

[Anonymous]

Hi Team,

Selected Date range March month and expected "Total Prod Val" value 2 NOT 5.

Total Prod Val = CALCULATE([Prod_Val],ALLEXCEPT('UID','UID'[UID])) 

Note : Prod Val is New Measure 

Thanks,

KV's

[amitchandak]

@Anonymous , I not able to see value 3 somehwre , try all or allselected

one of 4

Total Prod Val = CALCULATE([Prod_Val],all('UID'[UID]))

Total Prod Val = CALCULATE([Prod_Val],all('UID'))

Total Prod Val = CALCULATE([Prod_Val],allselected('UID'[UID]))

Total Prod Val = CALCULATE([Prod_Val],allselected('UID'))

[Anonymous]

Hi @amitchandak ,

above function are working overall sum, but i'm expected UID wise (sum for same UID)
For example : UID 44.OIU sum is 5 

  

[amitchandak · Accepted solution]

@Anonymous , while allexcept should have worked, try one of the two 

Total Prod Val = CALCULATE([Prod_Val],filter(ALL('UID'),'UID'[UID] =max('UID'[UID])))

Total Prod Val = CALCULATE([Prod_Val],filter(allselected('UID'),'UID'[UID] =max('UID'[UID])))

[Anonymous]

Hi @amitchandak ,

This is working fine.. Thanks 🙂