Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

All Selected Formula Help

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!

 

Need Help

3 Replies

  • AlB's avatar
    AlB
    Community Champion
    5 years ago

    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 

  • v-lionel-msft's avatar
    v-lionel-msft
    Community Support
    5 years ago

    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.

  • v-lionel-msft's avatar
    v-lionel-msft
    Community Support
    5 years ago

    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.