Combined to use both ALLSELECTED and ALLNOBLANKROW in an AVERAGEX/SUMX/STDEVX measure forumla

[mrothschild]

I have the following code for a measure:

 Measure = 

            STDEVX.S(
                SUMMARIZE (
                        ALLSELECTED('Table'),
                        'Table'[Column]

                    )
                , [Measure]
            )

I have programmed the same measure as follows

Measure (alt)= 

           STDEVX.S(
                SUMMARIZE (
                        ALLNOBLANKROW('Table'),
                        'Table'[Column]

                    )
                , [Measure]
            )

If I use the former, my dashboard/report is interactive as intended but has errors that cause some line charts to not appear properly.  If I use the latter, the line charts work, but then I lose the slicer functionality required.  

Is there a generic proper code format to incorporate both ALLSELECTED and ALLNOBLANKROW?

[Greg_Deckler · Accepted solution]

@mrothschild Maybe:

 Measure = 

            STDEVX.S(
                SUMMARIZE (
                        ALLNOBLANKROW(ALLSELECTED('Table')),
                        'Table'[Column]

                    )
                , [Measure]
            )

[mrothschild]

Didn't quite work, but the problem was upstream from there returning blanks when I didn't need to.