The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
I have three measures:
1. Spend
2. Transactions
3. ROI
I'm plotting these measures in a line chart:
1. Spend on x-axis (converted this to a column to plot it)
2. Transactions on y-axis
3. ROI on secondary y-axis
I'm trying to work out a DAX that returns true on the intersection point when plotted on y-axis
It seems to me like the intersection is not uniquely determined but depends on the relative scaling of your two y-axes. Is there a natural interpretation of what the intersection means from a business perspective?
User | Count |
---|---|
15 | |
12 | |
8 | |
7 | |
7 |
User | Count |
---|---|
24 | |
21 | |
12 | |
10 | |
7 |