Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Reply
Nfuentes86
Frequent Visitor

Power Bi Matrix Excluding Rows

Nfuentes86_0-1712952741929.png

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.
Nfuentes86_1-1712952827330.png

 

2 REPLIES 2
v-kongfanf-msft
Community Support
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] ) )
        )
    )
)

vkongfanfmsft_0-1713148949179.png

 

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_0-1713363153601.png

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

 

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.