cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
moll45 Frequent Visitor
Frequent Visitor

Issue with calculating median using filters

So I have a date table like this:

Capture.PNG

 

Formula for "Median Time Taken Performance (Over Time)", which is supposed to show the median time taken for all items with the specific date is

Median Time Taken Performance (Over Time) = CALCULATE(MEDIANX('FACT','FACT'[Time Taken]*1.0),FILTER('FACT','FACT'[Column]='Date Table'[Date]),FILTER('FACT','FACT'[Time Taken]>=0)).

 

However, for some reason it is not showing a median for some of the dates, even though there is 'Time Taken' data available for those dates in the FACT table:

Untitled.jpg

 If anyone could tell me where I'm going wrong, that would be much appreciated,

1 ACCEPTED SOLUTION

Accepted Solutions
moll45 Frequent Visitor
Frequent Visitor

Re: Issue with calculating median using filters

Hi AIB,

 

Thanks for your response but I discussed it with a colleague and turns it was because there were a lot of blanks for those days and so the blanks were becoming the median.

 

Thanks anyway for your offer of help!!

2 REPLIES 2
Super User
Super User

Re: Issue with calculating median using filters

Hi @moll45

 

Can you share the pbix?

moll45 Frequent Visitor
Frequent Visitor

Re: Issue with calculating median using filters

Hi AIB,

 

Thanks for your response but I discussed it with a colleague and turns it was because there were a lot of blanks for those days and so the blanks were becoming the median.

 

Thanks anyway for your offer of help!!