How to show sum few items and show in 1 item

[aamirkhan_WT]

Hi All

I am doing substraction few item but show its shwoing test it showing few time

Test = [NetSales] - [StaffCosts(PreBonus)_MTD]- [Establishment_MTD] - [G&ACost_MTD]- [NWC_AgingProvision_MTD]

I want to show the Total only not all item , can you help on this dax what should I do

[Anonymous · Accepted solution]

Hi @aamirkhan_WT ,

As I understand it, do you want every row of the matrix to return a total?

Maybe adding the ALL function helps you.

Test =
CALCULATE (
    [NetSales] - [StaffCosts(PreBonus)_MTD] - [Establishment_MTD] - [G&ACost_MTD] - [NWC_AgingProvision_MTD],
    ALL ( 'TABLENAME' )
)

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[aamirkhan_WT]

In the Table I want show below thing only 

_AMeasure minus StaffCosts(PreBonus)_MTD       13756 

[aamirkhan_WT]

Can any one help me on above issue