Forum Discussion

kostask's avatar
kostask
Helper II
3 years ago
Solved

Sumarrizing problem

Hi guys! I have a table (Production)  in which there is the daily production of the company's personnel. Above a production limit, a productivity bonus is given. The logic is simple: DayBonus = IF...
  • johnt75's avatar
    johnt75
    3 years ago

    Try

    Bonus =
VAR SummaryTable =
    ADDCOLUMNS (
        SUMMARIZE ( 'Production', 'Production'[Employee ID], 'Date'[Date] ),
        "@value",
            IF (
                CALCULATE ( SUM ( 'Production'[Production] ) ) >= [ProductionTarget],
                10,
                BLANK ()
            )
    )
RETURN
    SUMX ( SummaryTable, [@value] )
johnt75's avatar
johnt75
Super User
3 years ago

Try

Bonus =
VAR SummaryTable =
    ADDCOLUMNS (
        SUMMARIZE ( 'Production', 'Production'[Employee ID], 'Date'[Date] ),
        "@value",
            IF (
                CALCULATE ( SUM ( 'Production'[Production] ) ) >= [ProductionTarget],
                10,
                BLANK ()
            )
    )
RETURN
    SUMX ( SummaryTable, [@value] )
  • kostask's avatar
    kostask
    Helper II
    3 years ago

    johnt75 works fine!

    Thank you.