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.
Hello, I'm relatively new to Power BI. Need help with median and standard deviation DAX functions (MEDIAN and
STDEV.P)
Both accept only reference to a column. I need to use MEASURE which is monthly TOTALs . Need to show on line chart monthly totals over a period of 2 years along with Median and Stand. deviation. Your help is much appreciated!!!
Solved! Go to Solution.
Thank you so much for your response. Not sure how to apply your formulla to my case. I've created a measure:
Total Inpatient Orders = CALCULATE(COUNTROWS(distinct(OPIOIDS[IDcode])), FILTER (OPIOIDS,OPIOIDS[IsGiven] = 1))
I got a perfect monthly linechart for a few years that shows montly Total Inpatient Orders. Now need to apply MEDIAN and Standard Deviation to this chart. Any suggestions?
Thanks again
If understand correctly, you want to find Standard deviation and median grouped by monthly totals. You may want to create a Summarize or Summarize Column.
It should look something like:
STDEVX.P(
SUMMARIZE(
[Table],
'Table'[Date].[Month],
"Total", Sum([Sales])
),
[Total]
)
Please let me know if this works.
Regards
Thank you so much for your response. Not sure how to apply your formulla to my case. I've created a measure:
Total Inpatient Orders = CALCULATE(COUNTROWS(distinct(OPIOIDS[IDcode])), FILTER (OPIOIDS,OPIOIDS[IsGiven] = 1))
I got a perfect monthly linechart for a few years that shows montly Total Inpatient Orders. Now need to apply MEDIAN and Standard Deviation to this chart. Any suggestions?
Thanks again
Replace SUM(Sales) with [Total Inpatient Orders] and 'Table'[Date] with whatever date column you are using.
Hope that helps 😁
Thank you so much. I was able to create a stand. dev. measure. But when I try to place it into Values on my chart, I see the 'hour glass' sign for long, and never finishes. Like Cortesian product in Transact SQL. Any idea?
Thank you
Never mind. I;ve found the issue. My mistake. Thank you
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |