Join 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!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
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).
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 104 | |
| 81 | |
| 66 | |
| 50 | |
| 45 |