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

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

Single Table Sales_transaction 
columns :  Customer Key , Document type , Net Amount 
Dax :

Customer Deliveries 2.1 = var table_ = SUMMARIZE(SALES_DOCUMENTS,
SALES_DOCUMENTS[CUSTOMER_KEY],

 

"Deliveries",CALCULATE(DISTINCTCOUNT(SALES_DOCUMENTS[CUSTOMER_KEY]),SALES_DOCUMENTS[DOCUMENT_TYPE] IN {"SI","SO"},SALES_DOCUMENTS[NET_AMOUNT] > 1)) return SUMX(table_,[Deliveries])
 
But returning total is not correct in matrix 
Anonymous's avatar
Anonymous
Not applicable
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