% total of metric breaks when data filtered

[StephenF]

I have measure:

% Starts = SUM(STREAMS[Playlist Starts]) / SUMX(ALL(STREAMS),[Playlist Starts])

When the table this column appears in is filtered on another dimension, say [date] the denominator acts like its not affected by the filter but the numerator is.

How do I change this formula to get the correct results?

[v-jiascu-msft · Accepted solution]

Hi @StephenF,

Try this one, please. The structure of your mode is the key point.

% Starts =
SUM ( STREAMS[Playlist Starts] )
    / CALCULATE (
        SUMX ( STREAMS, [Playlist Starts] ),
        ALLEXCEPT ( STREAMS, STREAMS[date] )
    )

Best Regards,
Dale

[AlB]

Hi @StephenF

What exactly are the "correct results" that you wish? Your code acting is acting as it should 

[StephenF]

I wish for the denominator to be filtered.

[AlB]

@StephenF

But then you'll always get a 1, won't you? What would be the difference between the numerator and the denominator then?

[StephenF]

Yes it will be 1 but it will be correct for that table. The % Total needs to be local to the table object not global.

Consider the following end result as example

Filter: Date=yesterday

Dim1 %Total

dimA 66%

dimB 32%

dimC 2%

Total 100%

[AlB]

@StephenF

Maybe if you share the pbix I'd be able to help. It's too little information right now