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"
    )
)
ValtteriN's avatar
ValtteriN
Icon for Community Champion rankCommunity Champion
4 years ago

Hi,

I think the most straightforward solution is to filter DS_DUBFORM on a visual level so either just place a filter here: 



Or include a slicer selection on your report and use a simple dax like:
Revenue = SUM('AX_CUSTINVOICETRANS'[LINEAMOUNTMST])

If there isn't any specific reason to hard-code your product category selection I would stick to a slicer selection or a filter.

E.g. Slicer (in your example place 'AX_CUSTINVOICETRANS'[DS_PUBFORM] in the slicer)



I hope this helps and if it does consider accepting this as a solution and giving the post a thumbs up!