Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
I have to create a view of the TOP 5 products sold with applicable GEO and other filters/slicers (product group and similar - only using GEO in the example). My problem is with showing, what portion the TOP 5 products represent of the total revenue when the filters are applied. I need a calculation, that would adjust based on the slicers, but would ignore the TOPN filter setting and sum the revenue for all products for the given slicer setup.
For Total revnue here I have the function
Hi @bundipapa ,
What about allexcepting GEO field so that the GEO filter will be applied to your Total revenue measure?
Best regards,
User | Count |
---|---|
107 | |
89 | |
81 | |
76 | |
73 |
User | Count |
---|---|
112 | |
104 | |
96 | |
74 | |
66 |