SUMIF without Filter

Question

Hi good people,&nbsp;Need a help.&nbsp;I have a measure&nbsp;Shift A = CALCULATE(&nbsp;&nbsp;&nbsp;&nbsp;SUM('Database'[Actual Production (Carton)]), FILTER(Database,Database[Shift]="A")&nbsp;&nbsp;&nbsp;)&nbsp;I want to SUM [Actual Production (Carton)] where Shift is A but I also want to show all the other rows which does not have any value for Shift A. Currently this measure is filtering and showing only rows which has value for Shift A. How do i do it?

amitchandak · Answer

TryShift A =
CALCULATE(
    SUMX('Database', If(Database,Database[Shift]="A",[Actual Production (Carton)],0))   
)&nbsp;Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @ Thanks. My Recent Blog -Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners , HR-Analytics-Active-Employee-Hire-and-Termination-trendPower-BI-Working-with-Non-Standard-Time-Periods And Comparing-Data-Across-Date-RangesConnect on Linkedin

anonymous · Answer

Try this,Sumx(table,if(table[col]="A",table[quantity],0))Cheers,PravinIf it resolves your problem Mark it as solution and give Kudos.

anonymous · Answer

Can you please share screenshot of issue.

anonymous · Answer

This is my measure:&nbsp;Shift A = CALCULATE(&nbsp;&nbsp;&nbsp;&nbsp;SUMX(Database,IF(Database[Shift]="A",Database[Actual Production (Carton)],0)))&nbsp;This is my relation:&nbsp;This is the table I want to make, where I will have all the "Product Name" from the "List" table. I want to calculate shift wise production for every single product. In the following table, "AGI" and "Product Name" is from "List" table (because it contains the full list).&nbsp;You see in this photo, it has rightly calculated Shiftwise production, but it is now filtering the product names which has no production. I want the Product Names to be there although there is no production.&nbsp;

anonymous · Answer

Have you tried my solution?

Forum Discussion

SUMIF without Filter

6 Replies

Related content

SumIf

sumif not working

SUMIFS

SUMIF Function

Sumifs in power query