Forum Discussion

AleksandrG's avatar
AleksandrG
Icon for Helper I rankHelper I
3 years ago
Solved

DAX. Filtering the calculation through a parameter.

Guys, hello! Please help me to solve the following problem. I want to calculate the lost profit only for products whose profit is less than the specified value in the parameter. I created a meas...
Need Help
Show and Tell
  • AleksandrG's avatar
    AleksandrG
    3 years ago

    here is the solution 🙂

    VAR _table =
        FILTER (
            ADDCOLUMNS (
                Assortment4,
                "Persent", CALCULATE ( [% Profit], ALLSELECTED ( 'Calendar' ) ),
                "Profit", CALCULATE ( [Profit], ALLSELECTED ( 'Calendar' ) ),
                "SalesQty", CALCULATE ( [Sales Qty], ALLSELECTED ( 'Calendar' ) ),
                "SalesPerDay", CALCULATE ( [Sales Per Day], ALLSELECTED ( 'Calendar' ) )
            ),
            [Persent] > '% Profit'[Meaning % Profit]
        )
    RETURN
        SUMX (
            _table,
            IF (
                [Remainder] = 0,
                DIVIDE ( [Profit], [SalesQty], 0 ) * [SalesPerDay]
            )
        )

     

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

AleksandrG , to filter a measure you need to force a group by. or use measure in the visual level filter

 

example

suxm(filter(values(Table[Name]), [percent] < selectedvalue(whatif[value]) ), [Measure])