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.
Hello Team,
Can we pass slicer selection on to DAX query..
I'm using following DAX query
SUMMARIZE( ABC , ABC[Region] , "Sum" , SUM(ABC[OrderValue]))
I'm using same query for few other summary selections based on other fields , I was planning to have a slicer with options to select the summary output by region/category/type etc..
hi @kkalyanrr,
If your tables are connected with relationships than I am sure slicer will work on the result of the formula you wrote. Just Give it a try once. Just in case if it doesn't work then kindly share your pbix file or some sample data with the tentative result you desire to achieve.
Regards,
Hemant
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 |
---|---|
113 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |