Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredJoin us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM. Register now.
Hello again,
I've posted a couple of queries today DAX - How to use a Column Value to use in a Measure and DAX - Joining Tables and Measures and am close to finalising a report - I'd appreceiate some help with my next step.
I now have a table like the below. I would like to calculate Table.Number * Measure.Day % x to give the results in the 'Help Please' column.
Please can someone help me with a query to identify those row values in the Table.Number column?
| Table.Date | Table.Salesperson | Table.$ Amount | Table.Number | Measure.Total | Measure.Day % | Help Please |
| 1st Feb | Bob | 200 | 1 | 1000 | 20% | 0.2 |
| 1st Feb | Jessica | 200 | 1 | 1200 | 17% | 0.166666667 |
| 2nd Feb | Bob | 300 | 2 | 1000 | 30% | 0.6 |
| 2nd Feb | Jessica | 400 | 2 | 1200 | 33% | 0.666666667 |
| 3rd Feb | Bob | 500 | 3 | 1000 | 50% | 1.5 |
| 3rd Feb | Jessica | 600 | 3 | 1200 | 50% | 1.5 |
Many thanks
Gritman
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 8 | |
| 6 | |
| 3 | |
| 3 | |
| 3 |
| User | Count |
|---|---|
| 11 | |
| 9 | |
| 8 | |
| 7 | |
| 6 |