Forum Discussion
Solved
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]...
Total Sales USA = CALCULATE([TotalSales], [Coutry] = "USA")
This doesn't work in PowerBI Desktop
Yes, same with me, that solution does not work on PBD, not sure why that answer was selected as the right answer by the bot!
