Power Bi Total Column Excluding Discipline Names

[Nfuentes86]

I need to exclude Indirect and Change Orders from total column for  Sv,Cv,and Pf. 

Ive tried using this Dax Measure and keeps giving me errors : 

TotalExcludingIndirectsAndChangeOrders =

CALCULATE(

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

    FILTER(

        'ProgressWeeklyTable-6300263-1 (Linde)',

        NOT('ProgressWeeklyTable-6300263-1 (Linde)'[SV] = "Indirect" || 'ProgressWeeklyTable-6300263-1 (Linde)'[SV] = "Change Order" || ISBLANK('ProgressWeeklyTable-6300263-1 (Linde)'[SV]))

    )

)

[marcelsmaglhaes · Accepted solution]

Hey @Nfuentes86 

It looks like you're trying to create a measure to calculate the total of 'SV' column excluding values "Indirect" and "Change Order" as well as any blank values. Your approach seems correct, but the syntax might be causing the errors. Here's a revised version of your measure:

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

In this measure:

• We use <> operator to check for inequality.
• We use && instead of || for logical AND operator.
• We use NOT function around ISBLANK to exclude blank values.

Try using this revised measure and see if it resolves the errors you're encountering.

[Nfuentes86]

I tried this, but as you can see its not excluiding Change Orders or Indirects from summing into the Total Row Column 

I used: 

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

[marcelsmaglhaes · Accepted solution]

Hey @Nfuentes86 

It looks like you're trying to create a measure to calculate the total of 'SV' column excluding values "Indirect" and "Change Order" as well as any blank values. Your approach seems correct, but the syntax might be causing the errors. Here's a revised version of your measure:

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

In this measure:

• We use <> operator to check for inequality.
• We use && instead of || for logical AND operator.
• We use NOT function around ISBLANK to exclude blank values.

Try using this revised measure and see if it resolves the errors you're encountering.

[Nfuentes86]

Hi, its still not working. 

[marcelsmaglhaes]

What is the value in the column 'ProgressWeeklyTable-6300263-1 (Linde)'[SV]?

[Nfuentes86]

[marcelsmaglhaes · Accepted solution]

If there are numbers in the column 'ProgressWeeklyTable-6300263-1 (Linde)'[SV], you cannot compare it with text like 'ProgressWeeklyTable-6300263-1 (Linde)'[SV] <> "Indirect". You need to substitute that column with one that contains text you want ignore...