Dont show outliers outside of standard deviation limits

DAX DAX Calculations
1

HI

I am trying to make my graph not show the actual hours that fall outside the upper and lower limit of std deviation.

I calculated the std deviation

Standard Devi = CALCULATE(  
                    STDEVX.P(VALUES(Sheet[Shipset number]), 'Key Measures'[Actuals in Hours]),ALLSELECTED(Sheet[Shipset number]))

For example, in the graph below on the X axis for shipsets, Shipset 784, 785, 786 and 790 would be classed as outliers, and therefore I do not want these columns to show in the graph as it scews my average / mean and reads the actual average hours as 545.89 as its reading against all columns.

image
image887×367 81 KB

In the below example using the filters, I disable Shipset 784, 785, 786 and 790 and I get the true actual average shipset hours now with these 3 outlier ship sets removed of 534.30 hours

image
image886×370 74.4 KB

What I need is a way to adjust my dax so that the outliers don’t get added to the calculations and are not shown by default.

Any help would be appreciated. PBIX attached

SS Sold_All Programs EDNA.pbix (1.9 MB)

Thanks

Dan

1 Like
2

Hi @Krays23,
Thank you very much for posting your query in the forum.
If we create the following measure to know if a Shipset Number is within the range and apply it as a filter to the graph, could it be worth it?

Shipset Number in Range =

VAR _CurrentShipsetNumber = MAX( Sheet[Shipset number] )

VAR _VirtualTable = SELECTCOLUMNS(

    FILTER(

        ADDCOLUMNS(

            VALUES( Sheet[Shipset number] ),

                "@ActualsinHours", [Actuals IN Hours]

        ),

        [@ActualsinHours] >= [YMin] &&

        [@ActualsinHours] <= [YMax]

    ),

    "@ShipsetNumber", [Shipset number]

)

VAR _Result = IF(

    _CurrentShipsetNumber IN _VirtualTable,

    1,

    0

)

RETURN

_Result

image
image1262×508 115 KB

Regards,
SS Sold_All Programs EDNA_JAFP.pbix (1.9 MB)

2 Likes
3

Hi @Krays23, did the response provided by @jafernandezpuga help in solving your query? If not, how far did you get and what kind of help you need further? If yes, kindly mark as solution the answer that solved your query.

1 Like
4

HI

Thanks for that i need to give it a try I did get it working with this technique. is it similar to yours?

Filter Outliers = 
VAR CurrentSelection = SELECTEDVALUE('Is Outlier'[Selection])
VAR CurrentClass = [Is Outlier]
RETURN 
SWITCH(
    TRUE(),
    CurrentSelection = "Show Outliers Only" && CurrentClass = "Show Outliers Only", 1,
    CurrentSelection = "Remove Outliers" && CurrentClass = "Remove Outliers", 1,
    CurrentSelection = "All",1,
    0
)
1 Like
5

Hello @Krays23, good to see that you are having progress with your inquiry. Did the response from @jafernandezpuga helped you solve your inquiry?

If it does, kindly mark his answer as the as the solution to your query.

If not, how far did you get, and what kind of help do you need further?

6

Hello @Krays23 ,

@jafernandezpuga liked your post.

I would like to check with you again if the solution he provided solved your inquiry.

If it does, kindly mark his answer as the solution to your query.

If not, how far did you get, and what kind of help do you need further?

If we do not receive any feedback from you, we’ll tag the solution provided by @jafernandezpuga as the solution.

If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the check box.

We request you to kindly take time to answer the Enterprise DNA Forum User Experience Survey,We hope you’ll give your insights on how we can further improve the Support forum. Thanks!

1 Like
7

Hi @Krays23 due to inactivity, we’ll be marking this post as solved.

Should you wish to reopen this thread, kindly provide the PBIX file the experts requested above so other users can help you further.