Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello All,
I have a table called SALES. I need to show Product, Revenue, and Margin of Top 3 Product by Margin of products where Revenue is > 49 and Margin is also positive. Also only need Top 3 based on Revenue
Apprecite your help.
Solved! Go to Solution.
Hi @PBI_STARTER ,
I see two quick ways:
1) use the filter pane and select the filters according to your requirements:
2) you create a ranking measure, and drag it also in to the filter pane:
Here the measure:
TopNMeasure = RANKX ( ALLSELECTED ( Table ), CALCULATE ( MAX(Table[Revenue] ), Table[Revenue] > 49, Table[Margin] >= 0 ) )
Let me know if this helps 🙂
Did I answer your question❓➡️ Please, mark my post as a solution ✔️ |
Also happily accepting Kudos 🙂 |
Feel free to connect with me on LinkedIn! |
#proudtobeasuperuser |
Hi @PBI_STARTER ,
I see two quick ways:
1) use the filter pane and select the filters according to your requirements:
2) you create a ranking measure, and drag it also in to the filter pane:
Here the measure:
TopNMeasure = RANKX ( ALLSELECTED ( Table ), CALCULATE ( MAX(Table[Revenue] ), Table[Revenue] > 49, Table[Margin] >= 0 ) )
Let me know if this helps 🙂
Did I answer your question❓➡️ Please, mark my post as a solution ✔️ |
Also happily accepting Kudos 🙂 |
Feel free to connect with me on LinkedIn! |
#proudtobeasuperuser |
User | Count |
---|---|
99 | |
87 | |
81 | |
76 | |
71 |
User | Count |
---|---|
112 | |
105 | |
96 | |
74 | |
66 |