Classification of sales of a certain group of persons

DAX DAX Calculations
1

Hello,
I have a specific case where I need your help. I want to assign for a certain group of sellers the sales total of the whole transaction where they were involved. Does anyone have an idea how I can solve this scenario with Dax.

image
image812×278 11.9 KB

demo.pbix (19.8 KB)
demo.xlsx (10.7 KB)

2

@Mario

Measure = 
VAR VisibleTransactionID = 
    VALUES ( transactions[transaction_id] )
VAR Result = 
    CALCULATE ( 
        VAR TransactionTable = 
            transactions
        VAR SalesPerTransactionID = 
            ADDCOLUMNS (
                TransactionTable, 
                "@Sales", [Total Sales]
            )
        VAR Result = SUMX ( SalesPerTransactionID, [@Sales] )
        RETURN
            Result,
        VisibleTransactionID,
        REMOVEFILTERS ( transactions )
    )
RETURN 
    Result
2 Likes
3

Thanks @AntrikshSharma , that is exactly that i need

1 Like