This is best Fabric, Power BI, SQL and AI community event. How do we know? The last event sold out! Save €200 with code FABCMTY200.
Register nowThe Fabric community is now in read-only for platform upgrade. Learn more
Hello all!
My data in Power BI looks like so:
| Milestone | Count | Order |
| Lead | 500 | 01 |
| Credit | 250 | 02 |
| Closing | 50 | 03 |
I am looking to create a measure (or column) in Power BI which helps show the Milestone percentage between different milestones.
For example: I want to see the Lead to Credit Percentage (250/500), the Closing Percentage (50/100). How would I be able to create this using DAX?
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
| User | Count |
|---|---|
| 23 | |
| 22 | |
| 14 | |
| 14 | |
| 13 |
| User | Count |
|---|---|
| 47 | |
| 36 | |
| 24 | |
| 20 | |
| 20 |