SUMIF without Filter

[Anonymous]

Hi good people,

Need a help.

I have a measure

Shift A =

CALCULATE(

    SUM('Database'[Actual Production (Carton)]), FILTER(Database,Database[Shift]="A")   

)

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]

Try

Shift A =
CALCULATE(
    SUMX('Database', If(Database,Database[Shift]="A",[Actual Production (Carton)],0))   
)

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-trend
Power-BI-Working-with-Non-Standard-Time-Periods And Comparing-Data-Across-Date-Ranges

Connect on Linkedin

[Anonymous]

Try this,

Sumx(table,if(table[col]="A",table[quantity],0))

Cheers,
Pravin

If it resolves your problem Mark it as solution and give Kudos.

[Anonymous]

This is my measure:

Shift A =

CALCULATE(

    SUMX(Database,IF(Database[Shift]="A",Database[Actual Production (Carton)],0)))

This is my relation:

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

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.

[Anonymous]

Have you tried my solution?

[Anonymous]

Yes I did, this is the result.

[Anonymous]

Can you please share screenshot of issue.