Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
Sign up nowGet Fabric certified for FREE! Don't miss your chance! 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).
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
| User | Count |
|---|---|
| 63 | |
| 62 | |
| 42 | |
| 19 | |
| 16 |
| User | Count |
|---|---|
| 113 | |
| 105 | |
| 36 | |
| 28 | |
| 28 |