Forum Discussion

iqbalck's avatar
iqbalck
Frequent Visitor
9 years ago

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...
Need Help
v-caliao-msft's avatar
v-caliao-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

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

iqbalck's avatar
iqbalck
Frequent Visitor
9 years ago

Hi Charlie,

I am unable to do it. I have created the calculated measures from the attributes as show below: