Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 👍
User | Count |
---|---|
93 | |
85 | |
78 | |
68 | |
62 |
User | Count |
---|---|
113 | |
99 | |
96 | |
64 | |
58 |