Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowData Days is here! Join us now for 60+ days of learning, challenges, and connection. Learn more
Hi Team,
I'm having a column based on that I want to show the four measure values accordingly in the below format. Could you please help me how to get this or is this possible to achieve.
| Prodcut Account: Breakdown | Values/ Measure | Jan |
| 44927 | ||
| Product A | Revenue | 698095.78 |
| Cost | 542733.2 | |
| GMD | 155362.58 | |
| GMD (%) | 0.222551954 | |
| Prodcut B | Revenue | 124603.27 |
| Cost | 88224.97 | |
| GMD | 36378.3 | |
| GMD (%) | 0.291953012 | |
| Product C | Revenue | 822699.05 |
| Cost | 630958.17 | |
| GMD | 191740.88 | |
| GMD (%) | 0.233063208 | |
| Product D | Revenue | 300970.54 |
| Cost | 222363.9888 | |
| GMD | 78606.5512 | |
| GMD (%) | 0.261176895 | |
| Account Support | Revenue | 0 |
| Cost | 7156.49 | |
| GMD | -7156.49 | |
| GMD (%) |
How about something like this:
MyNewMeasure = if(SELECTEDVALUE('tableName'[BreakdownValues])="Revenue",[Revenue],if(SELECTEDVALUE('tableName'[BreakdownValues])="Cost",[Cost],if(SELECTEDVALUE('tableName'[BreakdownValues])="GMD",[GMD], [GMD%])))
I'm assuming you already have [Revenue], [Cost], [GMD] and [GMD%] measures, and Revenue / Cost / GMD / GMD (%) are rows in some table (which I've just called 'tableName' in my measure). If you don't have such a table, create one (but don't join it to anything).
Don't miss out on Data Days, June 15 through August 7. Learn Fabric, Power BI, SQL, AI and more.
Check out the May 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 23 | |
| 21 | |
| 20 | |
| 18 | |
| 13 |
| User | Count |
|---|---|
| 58 | |
| 50 | |
| 38 | |
| 31 | |
| 27 |