Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Help with DAX measure

For the following formula what could be the alternative in DAX ? As this formula takes a lot of time to render. 

CALCULATE(SUM('Warehouse ProjTransPosting'[AmountMst]),
FILTER( 'Warehouse ProjTransPosting',
('Warehouse ProjTransPosting'[TransactionTypeLabel] in
{"Hour", "Item","Expense", "On-account"}
 && 'Warehouse ProjTransPosting'[PostingTypeLabel] in
  {"Project - cost","Project - WIP - sales value", "Project - WIP invoiced - on account"})))
Need Help