Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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")
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
93 | |
77 | |
65 | |
53 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |