Power Bi Total Column Excluding Discipline Names

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.

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...