Forum Discussion
Dynamically applying commission percents
Hi BUNJ
Could you please provide sample data that fully represents your issue or question, in a usable format (e.g., Excel or CSV, not as a screenshot)?
-
Please ensure no sensitive or unrelated information is included.
-
Also, share the expected outcome based on the sample data you provide.
How to provide sample data in the Power BI Forum - Microsoft Fabric Community
-
Community Champion- Create a slicer for Product Group and another for Commission Percent (0.5% to 8%).
- Use a disconnected table for commission options.
- Write a DAX measure that applies the selected commission percent only to selected product groups.
- If no group is selected, it uses the default commission.
This lets you dynamically override commissions for multiple groups and see the impact instantly.