Forum Discussion
nuttybuddy
8 years agoFrequent Visitor
Use WHERE condition in DAX
Hi guys IN SAP Web intelligence, there is a WHERE function available just like SQL. I want to reproduce the below formula in a calculated column in PBI as below Total Sales USA = [TotalSales]...
- 8 years ago
Total Sales USA = CALCULATE([TotalSales], [Coutry] = "USA")
Greg_Deckler
8 years agoCommunity Champion
Total Sales USA = CALCULATE([TotalSales], [Coutry] = "USA")