cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Frequent Visitor

## Power Bi Matrix Excluding Rows

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.

2 REPLIES 2
Community Support

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,

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

Frequent Visitor

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] ) )
)
)
)