Sales1.md

% Commission total =

DIVIDE (
    CALCULATE (
        SUM ( '1-Sales Details'[NETAMOUNT] ),
       
        '1-Sales Details'[TENDERTYPE] <> "5"
    ),
    CALCULATE (
        SUM ( 'Commission target'[Amount] ),
        'Commission target'[Type] = "Total Target"
    )
)

% transaction without customer =

DIVIDE (
    COUNTROWS ( DISTINCT ( '1-Sales Details'[RECEIPTID] ) ),
    [Total sales Transactions]
)

Actual gender =

LOOKUPVALUE (
    'Employee Data'[GENDER],
    'Employee Data'[EMPLOYEECODE], '1-Sales Details'[STAFF]
)

Actual selling =

CALCULATE (
    MAX ( 'selling price standard'[FinalPrice] ),
    CROSSFILTER ( '1-Sales Details'[ITEMID], ItemMaster[Itemcode], BOTH )
)

Actual staff =

LOOKUPVALUE (
    'Employee Data'[EMPNAME],
    'Employee Data'[EMPLOYEECODE], '1-Sales Details'[STAFF]
)