topic Filter out the monthyear in DAX Commands and Tips

Filter out the monthyear

Easley06 — Fri, 22 Apr 2022 03:52:48 GMT

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

Re: Filter out the monthyear

amitchandak — Fri, 22 Apr 2022 04:23:05 GMT

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

Re: Filter out the monthyear

Easley06 — Fri, 22 Apr 2022 05:25:31 GMT

the filter for Monthyear

Re: Filter out the monthyear

v-chenwuz-msft — Tue, 26 Apr 2022 07:50:17 GMT

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.