Power Bi Matrix Excluding Rows

[Nfuentes86]

How can I exclude Change Orders and Indirects from the Total Column? 

I have tried : 

TotalExcludingIndirectsAndChangeOrders = CALCULATE( SUM('ProgressWeeklyTable-6300263'[SV]), FILTER( 'ProgressWeeklyTable-6300263', 'ProgressWeeklyTable-6300263'[Category] <> "Indirect" && 'ProgressWeeklyTable-6300263'[Category] <> "Change Order" && NOT(ISBLANK('ProgressWeeklyTable-6300263'[SV])) ) )

The outcome isn't doing what I need it to do. I need Indirects and Change Order NOT to be included in the Total Column. As we can tell here Original Colum (SV) Total is 4,646.00 with the Dax Measure is Giving the same 4646.

[Anonymous]

Hi @Nfuentes86 ,

Change your formula like below:

sum_ = SUM('Table'[Value])

result_ =
IF (
    HASONEVALUE ( 'Table'[Cagetory] ),
    SUM ( 'Table'[Value] ),
    CALCULATE (
        SUM ( 'Table'[Value] ),
        FILTER (
            ALL ( 'Table' ),
            'Table'[Cagetory] <> "Indirects"
                && 'Table'[Cagetory] <> "Change Order"
                && NOT ( ISBLANK ( 'Table'[Cagetory] ) )
        )
    )
)

Best Regards,
Adamk Kong

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

[Nfuentes86]

what do i do in this situation?

used --> 

result_ =

IF (

    HASONEVALUE ( 'ProgressWeeklyTable-6300263'[SV] ),

    SUM ( 'ProgressWeeklyTable-6300263'[SV] ),

    CALCULATE (

        SUM ( 'ProgressWeeklyTable-6300263'[SV] ),

        FILTER (

            ALL ( 'ProgressWeeklyTable-6300263' ),

            'ProgressWeeklyTable-6300263'[SV] <> "Indirects"

                && 'ProgressWeeklyTable-6300263'[SV] <> "Change Order"

                && NOT ( ISBLANK ( 'ProgressWeeklyTable-6300263'[SV] ) )

        )

    )

)