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

Anonymous — Fri, 01 Mar 2024 00:33:09 GMT

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

Date
Hour
deviceCategory
landingPage
sessionDefaultChannelSource

2 Facts

sessions
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.

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

lbendlin — Sat, 02 Mar 2024 23:04:24 GMT

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-Forum/ba-p/963216

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/1447523

topic Re: Measure to Compute 21Day Median of another Measure with 3 Dimensions in DAX Commands and Tips

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

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