All Selected Formula Help

[Anonymous]

Hello,

Any suggestions on creating a measure to show the % above/below the total. I.E.: Optimized is 58% above total, fresh is 5% above total, etc. I was thinking of showing a seperate matrix table below with the formula. Would I need to use the All Selected formula as I have two slicers above affecting the visuals on the page?

My current measure in the below table is taking Sales $/STR:

Sales $/STR = SUM('Holiday 2020'[Sales $])/DISTINCTCOUNT('WOW Wall - Holiday 2020'[Store + Name])

Thank you!

[v-lionel-msft]

Hi @Anonymous ,

Has your problem been solved?

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-lionel-msft]

Hi @Anonymous ,

Please try this.

Measure = 
VAR x = SUMX( ALLSELECTED(table), [Sales $/STR ] )
RETURN
DIVIDE(
    [Sales $/STR ] - x,
    x
)

If not, please provide sample data or .pbix file.

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[AlB]

Hi @Anonymous

Yep, ALLSELECTED(). You could use this measure in a matrix with the same columns as the one you have and nothing on the rows:

Measure =
DIVIDE (
    [Sales $/STR],
    CALCULATE ( [Sales $/STR], ALLSELECTED ( Table1[FieldInColumnsOfYourMatrix] ) )
)

 and format as % if necessary

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers