Forum Discussion
Issue with calculating median using filters
So I have a date table like this:
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:
If anyone could tell me where I'm going wrong, that would be much appreciated,
- Anonymous7 years ago
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
- AlB
Community Champion
Hi Anonymous
Can you share the pbix?
- AnonymousNot applicable
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!!