Forum Discussion

PBInterest's avatar
PBInterest
Frequent Visitor
5 years ago

Nested filters for case like statement

I have two lines of business and I want to summarize values over the combined lines of business. This data lives in the same table but some attributes only apply to one or the other business line. Bo...
CALCULATE
DAX
Filter
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

PBInterest , based on what I got

 

calculate([TotalSales],filter(Table, [BusinessLineId] <> 2)) + calculate([TotalSales],filter(Table, [BusinessLineId] = 2 && [SalesType] = "Retail" ))