Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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] where ([Coutry] = 'USA'
Any help will be greatly appreciated
thanks
Solved! Go to Solution.
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!
Total Sales USA = CALCULATE([TotalSales], [Coutry] = "USA")