Filtering by measure causes measure to recalculate - want it to remain static

[areimer]

My calculated field Volume Share is based off of the total Category ( i.e. brand 1 volume sales / category volume sales = 50%).

	Volume Sales	Volume Share
Category	100
brand 1	50	50%
brand 2	30	30%
brand 4	20	20%
brand 5	10	10%

When I apply a filter to look at only brands with a Volume Share >20%, Volume Share recalculates with the remaining values. I want it to remain static, showing the 50% and 30% values from above.

	Volume Sales	Volume Share
Category	60
brand 1	50	83%
brand 5	10	17%

Here's my formula...

Volume Share =

VAR Share_of_Category =

CALCULATE (

SUM ( non_vmi_fact_data_final_history[volume_sales] ), non_vmi_time_meta_data_final_history[Time Period] = "Latest 4 Weeks",

( ALLSELECTED ( non_vmi_product_meta_data_final_history[custom_brand_value] ) )

)

VAR Volume_Sales = CALCULATE(

    SUM(non_vmi_fact_data_final_history[volume_sales]),

    non_vmi_time_meta_data_final_history[Time Period] = "Latest 4 Weeks"

)

RETURN

ROUNDDOWN ( DIVIDE ( Volume_Sales, Share_of_Category ), 3 )

[Greg_Deckler]

@areimer Perhaps try ALL instead of ALLSELECTED?

[areimer]

No luck with ALL, numbers end up different than when using ALLSELETED, but there's still some calc going on. Thanks for the idea though.