Matrix returns some blank values.

Question

I've noticed that if an item has more than one value in a column, it returns blank, which I don't know how to fix. For anyone who is wondering What my 'DemandSummaryAPS'[Check] does is I take the data for week 45 and subtract it from 44. Some of my data only have 44 or 45, not both 44 and 45. If there is data for week 45, set it to 2. If it's 44, set it to 3 in 'DemandSummaryAPS'[Check]&nbsp;My DAXWeek 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]&nbsp; &nbsp; &nbsp; &nbsp; &amp;&amp; 'DemandSummaryAPS'[Check] = 1 || 'DemandSummaryAPS'[Check] = 2 || 'DemandSummaryAPS'[Check] = 3&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; SUMX(&nbsp; &nbsp; &nbsp; &nbsp; FILTER(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; FilteredTable,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'DemandSummaryAPS'[Week Num Create] = _max_week_num&nbsp; &nbsp; &nbsp; &nbsp; ),&nbsp; &nbsp; &nbsp; &nbsp; 'DemandSummaryAPS'[quantity]&nbsp; &nbsp; )&nbsp; &nbsp; &nbsp; &nbsp; VAR MinWeekNumCreate =&nbsp; &nbsp; SUMX(&nbsp; &nbsp; &nbsp; &nbsp; FILTER(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; FilteredTable,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'DemandSummaryAPS'[Week Num Create] = _min_week_num&nbsp; &nbsp; &nbsp; &nbsp; ),&nbsp; &nbsp; &nbsp; &nbsp; 'DemandSummaryAPS'[quantity]&nbsp; &nbsp; )VAR _Week_By_Week =&nbsp; &nbsp; IF(&nbsp; &nbsp; &nbsp; &nbsp; _max_demand_id = _min_demand_id,&nbsp; &nbsp; &nbsp; &nbsp; MaxWeekNumCreate - MinWeekNumCreate&nbsp; &nbsp; )VAR SUM_Week_By_Week =&nbsp; &nbsp; SWITCH(&nbsp; &nbsp; &nbsp; &nbsp; 'DemandSummaryAPS'[Check Measure],&nbsp; &nbsp; &nbsp; &nbsp; 1, _Week_By_Week,&nbsp; &nbsp; &nbsp; &nbsp; 2, MaxWeekNumCreate,&nbsp; &nbsp; &nbsp; &nbsp; 3, -MinWeekNumCreate,&nbsp; &nbsp; &nbsp; &nbsp; 0 &nbsp;// Default case, you can adjust this based on your requirement&nbsp; &nbsp; )RETURN&nbsp; &nbsp; SUM_Week_By_Week

lbendlin · Answer

Think like the Grand Total. Use SUMMARIZE or SUMMARIZECOLUMNS, even for the individual rows.
&nbsp;
Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue. If you are unsure how to do that please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216 Please show the expected outcome based on the sample data you provided. If you want to get answers faster please refer to https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Forum Discussion

Matrix returns some blank values.

1 Reply

Related content

Measure returning incorrect value

Date Different return wrong value

MAXX Returning duplicate values

PowerBI - Matrix table, hide values used only for a visual calculation

Return "Specific value" from table 1, if not found, return value from table 2