How to add calculated member which shows total Gross value?

Question

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

What SSAS model you use? Multidimensional or Tabular? – Jigar Jun 15 '17 at 20:52 — Jigar, Jun 15 '17 at 20:52

score 0 · Answer 1 · answered Mar 14 '18 at 15:29

0

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

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

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

answered Mar 14 '18 at 15:29

Jigar

As per my requirement , I need new columns which shows total sell value in each row. As per your example I need new columns which shows values 1000 in each three rows. – Nikunj Apr 14 '18 at 06:41

1 Answers1