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
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
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.
- Can you please share screenshot of issue.
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.