Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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,
Solved! Go to Solution.
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!!
Hi @Anonymous
Can you share the pbix?
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!!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
100 | |
88 | |
69 | |
61 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |