Forum Discussion

Tiger2514555's avatar
Tiger2514555
Icon for Helper III rankHelper III
2 years ago

SELECTEDVALU matrix total some BLANK

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: Wee...
Need Help
Tiger2514555's avatar
Tiger2514555
Icon for Helper III rankHelper III
2 years ago

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's avatar
    vanessafvg
    Icon for Community Champion rankCommunity Champion
    2 years ago

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

    • Tiger2514555's avatar
      Tiger2514555
      Icon for Helper III rankHelper III
      2 years ago

      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 =
          FILTER(
              'DemandSummaryAPS',
              'DemandSummaryAPS'[demandID] = 'DemandSummaryAPS'[demandID] &&
              'DemandSummaryAPS'[item] = 'DemandSummaryAPS'[item] &&
              'DemandSummaryAPS'[Week Num Due] = 'DemandSummaryAPS'[Week Num Due] &&
              'DemandSummaryAPS'[demandID] <> BLANK()
          )

      VAR _max_demand_id =
          MAXX(FilteredTable, 'DemandSummaryAPS'[demandID])

      VAR _min_demand_id =
          MINX(FilteredTable, 'DemandSummaryAPS'[demandID])

      VAR _max_week_num =
          MAXX(FilteredTable, 'DemandSummaryAPS'[Week Num Create])

      VAR _min_week_num =
          MINX(FilteredTable, 'DemandSummaryAPS'[Week Num Create])

      VAR MaxWeekNumCreate =
              SUMX(
                  FILTER(
                      FilteredTable,
                      'DemandSummaryAPS'[Week Num Create] = _max_week_num
                  ),
                  'DemandSummaryAPS'[quantity]
              )
             
      VAR MinWeekNumCreate =
              SUMX(
                  FILTER(
                      FilteredTable,
                      'DemandSummaryAPS'[Week Num Create] = _min_week_num
                  ),
                  'DemandSummaryAPS'[quantity]
              )


      VAR SUM_Week_By_Week =
          IF(
              _max_demand_id = _min_demand_id,
              SUMX(
                  VALUES('DemandSummaryAPS'[item]),
                  MaxWeekNumCreate - MinWeekNumCreate
              ),
              0
          )


      RETURN
          SUM_Week_By_Week

      vanessafvg