Forum Discussion

zivhimmel's avatar
zivhimmel
Icon for Resolver I rankResolver I
8 years ago
Solved

Different calculation in total line

Hi, I think this is impossible but thought I would try asking. I'm showing a table of transactions, with a total line. I'd like, for one of the fields, that the total line will show sum(field)/2. ...
Need Help
  • v-chuncz-msft's avatar
    v-chuncz-msft
    8 years ago

    zivhimmel,

     

    You may try the following DAX that adds a measure.

    Measure =
VAR v =
    SUM ( Table1[value] )
RETURN
    IF ( HASONEVALUE ( Table1[name] ), v, v / 2 )
v-chuncz-msft's avatar
v-chuncz-msft
Icon for Community Support rankCommunity Support
8 years ago

zivhimmel,

 

You may try the following DAX that adds a measure.

Measure =
VAR v =
    SUM ( Table1[value] )
RETURN
    IF ( HASONEVALUE ( Table1[name] ), v, v / 2 )