Filter out the monthyear

[Easley06]

Hi,

i have visual for this 

the answer should be this 

how to remove the filter in the visual using in the measure because im getting the wrong answer 

Measures:

MonthYear = [Short Month] & " " & [Year]

Short Month = FORMAT(mv_fact_sales_aggr[create_month_year],"MMM")

Year = year(mv_fact_sales_aggr[create_month_year])

Month Year Sort = FORMAT([date], "YYYYMM")

SOM = divide(sum(mv_fact_sales_aggr[Wfactor Sales]),CALCULATE(sum(mv_fact_sales_aggr[Wfactor Sales]),ALLSELECTED(mv_fact_sales_aggr[company],mv_fact_sales_aggr[brand_family_name],mv_fact_sales_aggr[brand_name],mv_fact_sales_aggr[product_name],mv_fact_sales_aggr[volpricetier],mv_fact_sales_aggr[regional],mv_fact_sales_aggr[zone],mv_fact_sales_aggr[area],mv_fact_sales_aggr[Year],mv_fact_sales_aggr[price_segment],mv_fact_sales_aggr[Weighting Factors],mv_fact_sales_aggr[segment],mv_fact_sales_aggr[product_classifier]),ALL(mv_fact_sales_aggr[brand_family_name]

,mv_fact_sales_aggr[create_month_year],mv_fact_sales_aggr[Month Year Sort],mv_fact_sales_aggr[create_month_year],mv_fact_sales_aggr[Short Month],mv_fact_sales_aggr[Year]

,mv_fact_sales_aggr[date])),0)*100

[amitchandak]

@Easley06 , which filter you want to remove and what you want to display ?

Always prefer a separate date table and other dimension tables. you can use all('DAte') and it will remove date filter and other dimensions filter will remain 

[Easley06]

the filter for Monthyear 

[v-chenwuz-msft · Accepted solution]

Hi @Easley06 ,

You can use REMOVERFILTERS() to remove the filter you want. And some measures like this :

DIVIDE (
    SUM ( mv_fact_sales_aggr[Wfactor Sales] ),
    CALCULATE (
        SUM ( mv_fact_sales_aggr[Wfactor Sales] ),
        REMOVEFILTERS ( mv_fact_sales_aggr[MonthYear] )
    )
)

Best Regards

Community Support Team _ chenwu zhu

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