Measure to Compute 21Day Median of another Measure with 3 Dimensions

[Prakash_CFA]

Hello All,
I need a measure to compute a 21 day median of another measure

I'm working on a web analytics dataset.

There are 5 Dimensions

1. Date
2. Hour
3. deviceCategory
4. landingPage
5. sessionDefaultChannelSource

2 Facts

1. sessions
2. engagedSessions

I have a measure called Bounce Rate

Bounce Rate = CALCULATE(DIVIDE(SUM('BounceRateData'[sessions])-SUM('BounceRateData'[engagedSessions]),SUM('BounceRateData'[sessions])))

I have a calendar table with all types of date based dimensions

I need to compute a 21 day median for the measure Bounce Rate, for a given set of Dimensions.
what i need is the median of bounce rate for the dimensions calculated at a day level and then the 21 day median calculated on top of this.

I've tried a number of ways to achieve this but none of it seems to work as desired.

I can create static calculated columns for each combination of dimensions but I'm looking for a way to calculate this on the fly for any combination of dimensions.

Thanks for all help.

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...