Mean line showing all columns

Power BI Data Model
1

HI,

Think this is a simple one i just cant think of how i done it before.

Basically i want the bottom graph in screen shot with my mean line measure added.

When i try and add it get all the blank columns show as shown in the top graph.

see screen shot and PBIX file.

Capture
Capture1853×747 172 KB

Sigma Test3.pbix (971.0 KB)

2

Hi Dan,

The reason for the blank columns appearing is that there’s no [Actual Minutes By Selected Sigma Level] value for each Ship Set on your axis BUT your Mean (μ) measure does have a value for each Ship Set… the measure below checks the [Actual Minutes By Selected Sigma Level] before returning the Mean (μ)

Mean (μ) no blanks = 

    IF( 
        ISBLANK( [Actual Minutes By Selected Sigma Level]) || [Actual Minutes By Selected Sigma Level] =0 | 
        BLANK() |
        IF(BLANK()|BLANK()|AVERAGEX(ALLSELECTED('SAP Last 40 Ship Sets (Hassan)')|[Actual Minutes]))
    )
3

Thanks Melissa

I have question what do the vertical lines mean ? as when i import them to my File i get errors i have had this before and cant remember how i solved it.

image
image.png1136×227 11.9 KB

Dan

4

Please replace the single vertical line with a comma if that is your list separator, the double vertical lines are equal to OR

1 Like