topic Re: Sumarrizing problem in DAX Commands and Tips

Sumarrizing problem

kostask — Tue, 28 Feb 2023 08:46:15 GMT

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(SUM(Production[Production])>=[ProductionTarget],10, BLANK())

So, the result on a table seems like this:

The row headers describe the employee number and the column headers, the date.

Dates come from a separate Date table. Employees' numbers exist only in the main table (Production)

How can I modify my formula to get the right summarized total results by row and by column?

Thank you

Kostas

Re: Sumarrizing problem

johnt75 — Tue, 28 Feb 2023 09:36:47 GMT

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] )

Re: Sumarrizing problem

kostask — Tue, 28 Feb 2023 11:03:02 GMT

johnt75 works fine!

Thank you.