Forum Discussion

LangeJan's avatar
LangeJan
Icon for Helper I rankHelper I
4 years ago
Solved

Table rows from measure not correct - Total amount correct

Hi I work for a bookstore will show how much of the turnover is sold in hard copy format ('Papir' in Danish). I have made the measure below. The total amount is correct (PFD not included), but in th...
measure
Measure Column Total
  • smpa01's avatar
    smpa01
    4 years ago

    LangeJan  try this

    Turnover PAPIR =
CALCULATE (
    SUM ( 'AX_CUSTINVOICETRANS'[LINEAMOUNTMST] ),
    FILTER (
        VALUES ( 'AX_CUSTINVOICETRANS'[DS_PUBFORM] ),
        'AX_CUSTINVOICETRANS'[DS_PUBFORM] = "papir"
    )
)
smpa01's avatar
smpa01
Icon for Community Champion rankCommunity Champion
4 years ago

LangeJan  try this

Turnover PAPIR =
CALCULATE (
    SUM ( 'AX_CUSTINVOICETRANS'[LINEAMOUNTMST] ),
    FILTER (
        VALUES ( 'AX_CUSTINVOICETRANS'[DS_PUBFORM] ),
        'AX_CUSTINVOICETRANS'[DS_PUBFORM] = "papir"
    )
)
  • LangeJan's avatar
    LangeJan
    Icon for Helper I rankHelper I
    4 years ago

    Thanks smpa01 - this solution solved my problem exactly as I wanted it.