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.
Hi everyone, i need help with this problem:
Look at this table:
[Sales]
And from that table i made this visual (The Standard Deviation value is 65.68)
The Standard Deviation that I need is not showing in this visual because is taking the values of [Average Sales Per day] and I need that takes the values like the table of the image #2 to take this Standard Deviation Result (114.39):
Thank You very much for reading.
Solved! Go to Solution.
Thanks, that helps. See solution below:
stdevm = CALCULATE(STDEVX.P(VALUES(Sales[Seller Name]);CALCULATE(sum(Sales[Average Sales per Day]))))
as seen here:
See modified Power BI file here.
If this is what you are looking for, please mark as solution. Kudo's appreciated.
Kind regards,
Steve.
Proud to be a Super User!
Awesome Keyboard Shortcusts in Power BI, thumbs up if you like the article
My Community Blog Articles (check them out!)
My Blog - Power M code to automatically detect column types -
How to create test data using DAX!
You need to use the STDEVX.P() function. Please try this approach
If this works for you, please mark it as solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Thanks for the response, in tried your recommendation but gave me another value the problem still look:
The right value is 114.40 in this case.
Can you share a Power BI file with a sample of your data so we can work with this?
Proud to be a Super User!
Awesome Keyboard Shortcusts in Power BI, thumbs up if you like the article
My Community Blog Articles (check them out!)
My Blog - Power M code to automatically detect column types -
How to create test data using DAX!
Thanks, that helps. See solution below:
stdevm = CALCULATE(STDEVX.P(VALUES(Sales[Seller Name]);CALCULATE(sum(Sales[Average Sales per Day]))))
as seen here:
See modified Power BI file here.
If this is what you are looking for, please mark as solution. Kudo's appreciated.
Kind regards,
Steve.
Proud to be a Super User!
Awesome Keyboard Shortcusts in Power BI, thumbs up if you like the article
My Community Blog Articles (check them out!)
My Blog - Power M code to automatically detect column types -
How to create test data using DAX!
Excelent!
Thank you both.
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 |
---|---|
40 | |
20 | |
18 | |
16 | |
15 |
User | Count |
---|---|
49 | |
26 | |
22 | |
17 | |
16 |