Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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")
User | Count |
---|---|
86 | |
82 | |
68 | |
64 | |
55 |
User | Count |
---|---|
120 | |
99 | |
91 | |
83 | |
65 |