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