Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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 :
Solved! Go to 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:
<>
operator to check for inequality.&&
instead of ||
for logical AND operator.NOT
function around ISBLANK
to exclude blank values.Try using this revised measure and see if it resolves the errors you're encountering.
Regards,
Marcel Magalhães
Microsoft Power BI Official Partner
MCT | Certified PL-300 Power BI
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...
Regards,
Marcel Magalhães
Microsoft Power BI Official Partner
MCT | Certified PL-300 Power BI
I tried this, but as you can see its not excluiding Change Orders or Indirects from summing into the Total Row Column
I used:
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:
<>
operator to check for inequality.&&
instead of ||
for logical AND operator.NOT
function around ISBLANK
to exclude blank values.Try using this revised measure and see if it resolves the errors you're encountering.
Regards,
Marcel Magalhães
Microsoft Power BI Official Partner
MCT | Certified PL-300 Power BI
Hi, its still not working.
What is the value in the column 'ProgressWeeklyTable-6300263-1 (Linde)'[SV]?
Regards,
Marcel Magalhães
Microsoft Power BI Official Partner
MCT | Certified PL-300 Power BI
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...
Regards,
Marcel Magalhães
Microsoft Power BI Official Partner
MCT | Certified PL-300 Power BI
User | Count |
---|---|
123 | |
69 | |
67 | |
58 | |
52 |
User | Count |
---|---|
183 | |
92 | |
67 | |
62 | |
53 |