Forum Discussion

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

Maxtrix sub total is Blank

From my Measure Dax, it shows the data in each row and column correctly, but in the Sub total section, it doesn't show all of them. Some are Blank, some aren't. I want it to show the value even if it's 0. I want it. let it show

I don't know why, when I look in the table, it shows a value of 0.
My DAX

Week By Week =


VAR FilteredTable =
    FILTER(
        'DemandSummaryAPS',
        'DemandSummaryAPS'[demandID] = SELECTEDVALUE('DemandSummaryAPS'[demandID]) &&
        'DemandSummaryAPS'[Week Num Due] = SELECTEDVALUE('DemandSummaryAPS'[Week Num Due]) &&
        'DemandSummaryAPS'[Lastest] = 1
    )

VAR MaxWeekNumCreate =

SUMX(
    FILTER(
        FilteredTable,
        'DemandSummaryAPS'[Week Num Create] = MAXX(FilteredTable, 'DemandSummaryAPS'[Week Num Create])
    ),
    'DemandSummaryAPS'[quantity]
)

VAR MinWeekNumCreate = SUMX(
    FILTER(
        FilteredTable,
        'DemandSummaryAPS'[Week Num Create] = MINX(FilteredTable, 'DemandSummaryAPS'[Week Num Create])
    ),
    'DemandSummaryAPS'[quantity]
)
VAR SUM_Week_By_Week = MaxWeekNumCreate - MinWeekNumCreate
RETURN
    SUM_Week_By_Week
Need Help
Tutorial Requests

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Tiger2514555 

    You can try the following Measure

    Measure =
IF ( NOT ( ISBLANK ( [Week By Week] ) ), [Week By Week], 0 )

    Best Regards!

    Yolo Zhu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        Hi Tiger2514555 

        Can you show some sample data and the output you want?

         

        Best Regards!

        Yolo Zhu