Forum Discussion
SUMIF without Filter
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 [Actua...
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.
Sumx(table,if(table[col]="A",table[quantity],0))
Cheers,
Pravin
If it resolves your problem Mark it as solution and give Kudos.
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.
- Have you tried my solution?
Yes I did, this is the result.