Forum Discussion

mh2587's avatar
mh2587
Icon for Super User rankSuper User
4 years ago
Solved

Measure total is not correct

In the I just distinctcount one of the column but in matrix the total is incorrect Single Table Sales_transaction  columns :  Customer Key , Document type , Net Amount  Dax : Customer Deliv...
Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi mh2587 ,

     

    Please try calculating the value of the total column separately.

    SUMX(ALLSELECTED(table),[Customer Deliveries])

    Use ISINSCOPE() function to determine whether it is a total column and return different value.

    measure = IF(ISINSCOPE([Column filed]),[Customer Deliveries],SUMX(ALLSELECTED(table),[Customer Deliveries]))

    If I misunderstood your meaning, please share some sample data and expected result.

     

    Best Regards,

    Jay