SELECTEDVALU matrix total some BLANK

Question

I don't understand why when there are values ​​in more than one column the values ​​are returned as BLANK, but if there are only one column the values ​​are returned correctly.My DAX:Week By Week =VAR SelDemandID = SELECTEDVALUE(DemandSummaryAPS[demandID])VAR SelItem = SELECTEDVALUE(DemandSummaryAPS[item])VAR SelWeekDue = SELECTEDVALUE(DemandSummaryAPS[Week Num Due])VAR FilteredTable =&nbsp; &nbsp; FILTER(&nbsp; &nbsp; &nbsp; &nbsp; 'DemandSummaryAPS',&nbsp; &nbsp; &nbsp; &nbsp; 'DemandSummaryAPS'[demandID] = SelDemandID &amp;&amp;&nbsp; &nbsp; &nbsp; &nbsp; 'DemandSummaryAPS'[item] = SelItem &nbsp;&amp;&amp;&nbsp; &nbsp; &nbsp; &nbsp; 'DemandSummaryAPS'[Week Num Due] = SelWeekDue &amp;&amp;&nbsp; &nbsp; &nbsp; &nbsp; 'DemandSummaryAPS'[demandID] &lt;&gt; BLANK() &nbsp; &nbsp; )VAR _max_demand_id =&nbsp; &nbsp; MAXX(FilteredTable, 'DemandSummaryAPS'[demandID])VAR _min_demand_id =&nbsp; &nbsp; MINX(FilteredTable, 'DemandSummaryAPS'[demandID])VAR _max_week_num =&nbsp; &nbsp; MAXX(FilteredTable, 'DemandSummaryAPS'[Week Num Create])VAR _min_week_num =&nbsp; &nbsp; MINX(FilteredTable, 'DemandSummaryAPS'[Week Num Create])VAR MaxWeekNumCreate =&nbsp; &nbsp; &nbsp; &nbsp; SUMX(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; FILTER(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; FilteredTable,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'DemandSummaryAPS'[Week Num Create] = _max_week_num&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'DemandSummaryAPS'[quantity]&nbsp; &nbsp; &nbsp; &nbsp; )&nbsp; &nbsp; &nbsp; &nbsp; VAR MinWeekNumCreate =&nbsp; &nbsp; &nbsp; &nbsp; SUMX(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; FILTER(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; FilteredTable,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'DemandSummaryAPS'[Week Num Create] = _min_week_num&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'DemandSummaryAPS'[quantity]&nbsp; &nbsp; &nbsp; &nbsp; )VAR SUM_Week_By_Week =&nbsp; &nbsp; IF(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;_max_week_num = MAXX(FilteredTable, 'DemandSummaryAPS'[Week Num Create]) &amp;&amp; &nbsp;_min_week_num = MAXX(FilteredTable, 'DemandSummaryAPS'[Week Num Create] - 1),&nbsp; &nbsp; &nbsp; &nbsp; MaxWeekNumCreate - MinWeekNumCreate,&nbsp; &nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; )RETURN&nbsp; &nbsp; SUM_Week_By_Week

vanessafvg · Answer

selectedvalue() needs filter context or it will always show blank if giving multiple values as its intended for only one value.&nbsp;
&nbsp;
use a different aggregation function like max or min if you are looking at multiple values, you will still&nbsp; need to return one value.
&nbsp;
&nbsp;
https://www.sqlbi.com/articles/using-the-selectedvalue-function-in-dax/

tiger2514555 · Answer

But in my total there are several contexts that I think might need to be changed to a different one.

Because I need the difference of Week Num Create 45 and 44. with quantities which have many values in case I want to see in total.
So do you have any ideas on how to fix it?

vanessafvg · Answer

if you can provide some sample data with and example of your expected result then it will be easier to help you.

tiger2514555 · Answer

I have the same product but the DemandID is different. I want to compare volumes to see how much they increased or decreased using Week Num Create as a basis. Right now I'm using the most recent week and the previous week. Now I can get it to display correctly in the weekly column. But the total field is not displayed correctly. I want the correct total to be displayed.My DAX use now:Week By Week =VAR FilteredTable =&nbsp; &nbsp; FILTER(&nbsp; &nbsp; &nbsp; &nbsp; 'DemandSummaryAPS',&nbsp; &nbsp; &nbsp; &nbsp; 'DemandSummaryAPS'[demandID] = 'DemandSummaryAPS'[demandID] &amp;&amp;&nbsp; &nbsp; &nbsp; &nbsp; 'DemandSummaryAPS'[item] = 'DemandSummaryAPS'[item] &amp;&amp;&nbsp; &nbsp; &nbsp; &nbsp; 'DemandSummaryAPS'[Week Num Due] = 'DemandSummaryAPS'[Week Num Due] &amp;&amp;&nbsp; &nbsp; &nbsp; &nbsp; 'DemandSummaryAPS'[demandID] &lt;&gt; BLANK() &nbsp; &nbsp; )VAR _max_demand_id =&nbsp; &nbsp; MAXX(FilteredTable, 'DemandSummaryAPS'[demandID])VAR _min_demand_id =&nbsp; &nbsp; MINX(FilteredTable, 'DemandSummaryAPS'[demandID])VAR _max_week_num =&nbsp; &nbsp; MAXX(FilteredTable, 'DemandSummaryAPS'[Week Num Create])VAR _min_week_num =&nbsp; &nbsp; MINX(FilteredTable, 'DemandSummaryAPS'[Week Num Create])VAR MaxWeekNumCreate =&nbsp; &nbsp; &nbsp; &nbsp; SUMX(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; FILTER(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; FilteredTable,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'DemandSummaryAPS'[Week Num Create] = _max_week_num&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'DemandSummaryAPS'[quantity]&nbsp; &nbsp; &nbsp; &nbsp; )&nbsp; &nbsp; &nbsp; &nbsp; VAR MinWeekNumCreate =&nbsp; &nbsp; &nbsp; &nbsp; SUMX(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; FILTER(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; FilteredTable,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'DemandSummaryAPS'[Week Num Create] = _min_week_num&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'DemandSummaryAPS'[quantity]&nbsp; &nbsp; &nbsp; &nbsp; )VAR SUM_Week_By_Week =&nbsp; &nbsp; IF(&nbsp; &nbsp; &nbsp; &nbsp; _max_demand_id = _min_demand_id,&nbsp; &nbsp; &nbsp; &nbsp; SUMX(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; VALUES('DemandSummaryAPS'[item]), &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; MaxWeekNumCreate - MinWeekNumCreate&nbsp; &nbsp; &nbsp; &nbsp; ),&nbsp; &nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; )RETURN&nbsp; &nbsp; SUM_Week_By_Weekvanessafvg&nbsp;

Forum Discussion

SELECTEDVALU matrix total some BLANK

4 Replies

Related content

Totals in Matrix

Matrix Totals Incorrect

Selectedvalue

Formatting grand total in matrix

Matrix Row Totals