Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi Folks,
I need your help to figure out the issue I am facing right now. So I have two Dimension Supplier and their products and one measure sales. I have to create a matrix table that shows top supplier and their product information along with the sales. I tried to use Rankx along with the Allselected on supplier field, but if their is only supplier in the report the topn filter works perfectly
but when I added product id in the matrix report shows all the supplier
my requirement is to have only top supplier and their products list not all the products and supplier. I know this is happening because after adding product in the report their rank become 1 thats why they are on the report. But i do not know how to fix this issue. below is the code that I have used for rank
All the helps are greatly appriciated.
Thank you in advance
Solved! Go to Solution.
refer to the following
https://www.youtube.com/watch?v=Q_rMQ89ng70&ab_channel=EnterpriseDNA
User | Count |
---|---|
98 | |
91 | |
84 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
66 |