Forum Discussion
Calculated measure to be displayed on matrix visualisation
Hi All, I have created a few calculated fields and I need to show it in a matrix or table visualisation. But when I try to do that it shows description of the calculated measures as column header an...
v-caliao-msft
Microsoft Employee
Microsoft EmployeeHi iqbalck,
Please provide us some sample data, so that we can make further analysis.
Regards,
Charlie Liao
Hi Charlie,
Please find below sample data:
| Region | Country | Sales | Gross Profit | Net Profit |
| A | X | 100 | 35 | 15 |
| B | X | 110 | 33 | 27.5 |
| C | X | 120 | 48 | 54 |
| A | Y | 130 | 71.5 | 13 |
| B | Y | 140 | 35 | 32.2 |
| C | Y | 150 | 45 | 37.5 |
| A | Z | 160 | 56.64 | 19.2 |
| B | Z | 170 | 76.5 | 35 |
| C | Z | 180 | 56.7 | 45 |
I don't know how to attach excel file in here.
With the above data Gross Margin is to be calculated by dividing Gross Profit by Sales and Net Profit% by dividing Net Profit by Sales. After that the calculated measures Gross Margin & Net Profit% are to be displayed in Table or Matrix as shown below:
- v-caliao-msft
Hi iqbalck,
You can use a a multi-row card to display those two measures.
Cross% = "Cross%: "&FORMAT(SUM(Table2[Gross Profit])/SUM(Table2[Sales]),"0.00%")
Net% = "Net%: "&FORMAT(SUM(Table2[Net Profit])/SUM(Table2[Sales]),"0.00%")Regards,
Charlie Liao