WTD with respect to Calculated measure

[Anonymous]

Hi,

I want to calculate WTD with respect to measure value.

Here,Submissions Volume is a Calculated measure with combination other two Tables. 

Date Field is coming from Date Table.

I tried this,

Submission Volume WTD =CALCULATE( Submission[Submissions Volume], FILTER( ALL('Date'), 'Date'[Week-End_Date] <= MAX('Date'[Week-End_Date]) ) )

But not working,PFB.

I need Answer like below, Which is consolidated count of Submission Volume Measure with respect to week Wise.

I have Uploaded the Sample PBIX file in below drive, if possible work on that file and help me with this dax.

https://drive.google.com/file/d/1MEnTlniULSJmMA5WZxMJgyG6ceHRRzPf/view?usp=share_link

Thanks,

Mohanraj

@Greg_Deckler @amitchandak 

[Ahmedx · Accepted solution]

pls try this

Submission Volume WTD = 
VAR _t1 =
    ADDCOLUMNS (  GENERATE('Date',VALUES(Submission[SUBMISSION_STATUS])), "@Submissions Volume", [Submissions Volume] )
RETURN SUMX(VALUES('Date'[Week-End_Date]),
    SUMX ( _t1, [@Submissions Volume] ) )

 ======
Submission Volume WTD Fixed = CALCULATE([Submission Volume WTD],REMOVEFILTERS('Date'[Date]),REMOVEFILTERS(Submission[SUBMISSION_STATUS]))

 

[Anonymous]

Hi @Ahmedx 

Thanks a lot, Working Perfect!

[Anonymous]

Hi Ahmed,

Thanks for your reply!

For the same file which you uploaded in drive, If i Use Submission_Status and Weekend Date column alone, It is not working.

In My scenario i need to show Weekend and Submission Status ,like below. 

After that i need to do Divide(Submission Volume with Submission Volume WTD Fixed)

End Result will be like below,

Thanks,

Mohanraj

@Ahmedx @Ashish_Mathur 

[Ahmedx]

you need to write two measures like this:
Sample PBIX file attached

https://1drv.ms/u/s!AiUZ0Ws7G26RiCWojXTMORz-fJ-_?e=8UJXNw

[Ashish_Mathur]

Hi,

The answer should be 12 in the first 3 rows (not 13) probably becase an ID is repeating.  Anyways, try this measure for a start

Measure = CALCULATE([Submissions Volume],DATESBETWEEN('Date'[Date],Max('Date'[Week-End_Date])-7,Max('Date'[Week-End_Date])))

hope this helps.