How to add calculated member which shows total Gross value?

34 views Asked by At

How can I add calculated measure in SSAS which shows in attached image? Image

1

There are 1 answers

1
Jigar On

You can use following DAX formula in defining 'GrossValue' calculated measure as a new column,

GrossValue:=FactSellAndGrossValues[Sell]-FactSellAndGrossValues[Cost]

enter image description here

After evaluating that DAX expression, you will be able to see the calculated values for GrossValue as below,

enter image description here