Measure showing zero when not filtered

Question

I'm looking to show a measure to the same week in the previous fiscal year:&nbsp;&nbsp;LY Stock (sgls) = 
VAR currentFiscalYear =
    MAX ( 'Stock &amp; Sales'[fiscal_year] )
VAR currentFiscalWeek =
    MAX ( 'Stock &amp; Sales'[fiscal_week_number] )

RETURN
    CALCULATE (
        Sum('Stock &amp; Sales'[stock_sgls]), ALLSELECTED('Stock &amp; Sales'[bu]),
        FILTER (
            ALL ( 'Stock &amp; Sales' ),
            'Stock &amp; Sales'[fiscal_year]
                = currentFiscalYear - 1
                &amp;&amp; 'Stock &amp; Sales'[fiscal_week_number] = currentFiscalWeek 
    ),FILTER (
            ALL ( 'Stock &amp; Sales' ),'Stock &amp; Sales'[bu] = SELECTEDVALUE( ( 'Stock &amp; Sales'[bu] ))))&nbsp;&nbsp;However, when it's not filtered, it shows zero. I need it to show the total.&nbsp;Can someone help, please?

mahoneypat · Accepted Answer

Please try this expression instead.&nbsp; Not sure why you have the ALLSELECTED() in there and then filter it back down again with SELECTEDVALUE.&nbsp; In any case, the SELECTEDVALUE is why you were not seeing anything for total.&nbsp; I replaced it with VALUES.&nbsp; Also note that I updated your ALL to only include the columns being filtered (a good practice).
&nbsp;
LY&nbsp;Stock&nbsp;(sgls)&nbsp;=VAR&nbsp;currentFiscalYear&nbsp;=&nbsp;&nbsp;&nbsp;&nbsp;MAX&nbsp;(&nbsp;'Stock&nbsp;&amp;&nbsp;Sales'[fiscal_year]&nbsp;)VAR&nbsp;currentFiscalWeek&nbsp;=&nbsp;&nbsp;&nbsp;&nbsp;MAX&nbsp;(&nbsp;'Stock&nbsp;&amp;&nbsp;Sales'[fiscal_week_number]&nbsp;)RETURN&nbsp;&nbsp;&nbsp;&nbsp;CALCULATE&nbsp;(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;SUM&nbsp;(&nbsp;'Stock&nbsp;&amp;&nbsp;Sales'[stock_sgls]&nbsp;),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ALLSELECTED&nbsp;(&nbsp;'Stock&nbsp;&amp;&nbsp;Sales'[bu]&nbsp;),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;FILTER&nbsp;(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ALL&nbsp;(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;'Stock&nbsp;&amp;&nbsp;Sales'[fiscal_year],&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;'Stock&nbsp;&amp;&nbsp;Sales'[fiscal_week_number]&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;'Stock&nbsp;&amp;&nbsp;Sales'[fiscal_year]&nbsp;=&nbsp;currentFiscalYear&nbsp;-&nbsp;1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&amp;&amp;&nbsp;'Stock&nbsp;&amp;&nbsp;Sales'[fiscal_week_number]&nbsp;=&nbsp;currentFiscalWeek&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;VALUES&nbsp;(&nbsp;'Stock&nbsp;&amp;&nbsp;Sales'[bu]&nbsp;)&nbsp;&nbsp;&nbsp;&nbsp;)
Regards,
Pat
&nbsp;

Forum Discussion

Measure showing zero when not filtered

2 Replies

Related content

Dynamic measure filtering

Filter by Rank measure

How to show multiple metrics/measures in a visual?

Using measure as a filter

Adjust this measure to show totals