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 Power BI community,
I'd like to filter the cubeset "order by measure" so that I don't have to create separate measures in Excel Power Pivot data model for different GL accounts. I'd greatly appreciate it if anyone could let me know how I can create a sliceable cubeset "order by measure".
Thank you for your help.
Solved! Go to Solution.
Here are some examples of how to filter your set argument
Formula Cubeset values range with filter on secondary argument - Microsoft Community Hub
Here are some examples of how to filter your set argument
Formula Cubeset values range with filter on secondary argument - Microsoft Community Hub
Big thanks to you @lbendlin . Exists function did exactly what I wanted to do 👍
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 |
---|---|
104 | |
95 | |
80 | |
67 | |
62 |
User | Count |
---|---|
138 | |
107 | |
104 | |
82 | |
63 |