Forum Discussion

datawomen's avatar
datawomen
Regular Visitor
3 years ago
Solved

Dax table

i am trying to build a table from a variable created inside a measure. I basically wants to select a maximum of the maximum values. My best thought was to create a variable for  each column then feed...
Need Help
  • sevenhills's avatar
    sevenhills
    3 years ago

    I am not sure whether you are looking for a measure or dax data table syntax. I am providing both syntax.

     

    Measure to get max of max:

     

    Max Measure Name = 
MAXX(
	{
		  MAX('Agent IdleTimes'[Bathroom Break - Count])
		, MAX('Agent IdleTimes'[Boards - Dispatch - Count])
		, MAX('Agent IdleTimes'[Break - 15 Mins - Count])
		, MAX('Agent IdleTimes'[Customer Call Back - Count])
		, MAX('Agent IdleTimes'[Dispatch Support - Outbound Calls - Count])
		, MAX('Agent IdleTimes'[Email - Count])
		, MAX('Agent IdleTimes'[IT Issues - Support - Count])
		, MAX('Agent IdleTimes'[Incident Report - Dispatch Only -Count])
		, MAX('Agent IdleTimes'[Lunch - 30 Mins - Count])
		, MAX('Agent IdleTimes'[Meeting - Count])
		, MAX('Agent IdleTimes'[Segment Alerts - Faxes - Count])
		, MAX('Agent IdleTimes'[Supervisor Support - Armand - Count])
		, MAX('Agent IdleTimes'[Training - Count])
		, MAX('Agent IdleTimes'[Unavailable - Logged In - Count])
		, MAX('Agent IdleTimes'[Wrap up - Extended - Count])
	}
	,
    [Value]
)

     

     

    Table with just one column and one row with max of maxes 

    Click New table and paste this dax

     

    Table 1 =  ROW ( "Max Measure Name", 
MAXX(
	{
		  MAX('Agent IdleTimes'[Bathroom Break - Count])
		, MAX('Agent IdleTimes'[Boards - Dispatch - Count])
		, MAX('Agent IdleTimes'[Break - 15 Mins - Count])
		, MAX('Agent IdleTimes'[Customer Call Back - Count])
		, MAX('Agent IdleTimes'[Dispatch Support - Outbound Calls - Count])
		, MAX('Agent IdleTimes'[Email - Count])
		, MAX('Agent IdleTimes'[IT Issues - Support - Count])
		, MAX('Agent IdleTimes'[Incident Report - Dispatch Only -Count])
		, MAX('Agent IdleTimes'[Lunch - 30 Mins - Count])
		, MAX('Agent IdleTimes'[Meeting - Count])
		, MAX('Agent IdleTimes'[Segment Alerts - Faxes - Count])
		, MAX('Agent IdleTimes'[Supervisor Support - Armand - Count])
		, MAX('Agent IdleTimes'[Training - Count])
		, MAX('Agent IdleTimes'[Unavailable - Logged In - Count])
		, MAX('Agent IdleTimes'[Wrap up - Extended - Count])
	}
	,
    [Value]
)

)

     

     

    Hope it helps!

sevenhills's avatar
sevenhills
Super User
3 years ago

I am not sure whether you are looking for a measure or dax data table syntax. I am providing both syntax.

 

Measure to get max of max:

 

Max Measure Name = 
MAXX(
	{
		  MAX('Agent IdleTimes'[Bathroom Break - Count])
		, MAX('Agent IdleTimes'[Boards - Dispatch - Count])
		, MAX('Agent IdleTimes'[Break - 15 Mins - Count])
		, MAX('Agent IdleTimes'[Customer Call Back - Count])
		, MAX('Agent IdleTimes'[Dispatch Support - Outbound Calls - Count])
		, MAX('Agent IdleTimes'[Email - Count])
		, MAX('Agent IdleTimes'[IT Issues - Support - Count])
		, MAX('Agent IdleTimes'[Incident Report - Dispatch Only -Count])
		, MAX('Agent IdleTimes'[Lunch - 30 Mins - Count])
		, MAX('Agent IdleTimes'[Meeting - Count])
		, MAX('Agent IdleTimes'[Segment Alerts - Faxes - Count])
		, MAX('Agent IdleTimes'[Supervisor Support - Armand - Count])
		, MAX('Agent IdleTimes'[Training - Count])
		, MAX('Agent IdleTimes'[Unavailable - Logged In - Count])
		, MAX('Agent IdleTimes'[Wrap up - Extended - Count])
	}
	,
    [Value]
)

 

 

Table with just one column and one row with max of maxes 

Click New table and paste this dax

 

Table 1 =  ROW ( "Max Measure Name", 
MAXX(
	{
		  MAX('Agent IdleTimes'[Bathroom Break - Count])
		, MAX('Agent IdleTimes'[Boards - Dispatch - Count])
		, MAX('Agent IdleTimes'[Break - 15 Mins - Count])
		, MAX('Agent IdleTimes'[Customer Call Back - Count])
		, MAX('Agent IdleTimes'[Dispatch Support - Outbound Calls - Count])
		, MAX('Agent IdleTimes'[Email - Count])
		, MAX('Agent IdleTimes'[IT Issues - Support - Count])
		, MAX('Agent IdleTimes'[Incident Report - Dispatch Only -Count])
		, MAX('Agent IdleTimes'[Lunch - 30 Mins - Count])
		, MAX('Agent IdleTimes'[Meeting - Count])
		, MAX('Agent IdleTimes'[Segment Alerts - Faxes - Count])
		, MAX('Agent IdleTimes'[Supervisor Support - Armand - Count])
		, MAX('Agent IdleTimes'[Training - Count])
		, MAX('Agent IdleTimes'[Unavailable - Logged In - Count])
		, MAX('Agent IdleTimes'[Wrap up - Extended - Count])
	}
	,
    [Value]
)

)

 

 

Hope it helps!