Pivot Measures in Powerbi

Try this

union(
SUMMARIZE(table, table[any Group by col], "Engagement","Engaged","CountEngagement" , sum(table[Engaged])),
SUMMARIZE(table, table[any Group by col], "Engagement","Disengaged","CountEngagement" , sum(table[Disengaged])),
SUMMARIZE(table, table[any Group by col], "Engagement","ActivelyDisengaged","CountEngagement" , sum(table[ActivelyDisengaged]))
)

or

union(
SUMMARIZE(table, "Engagement","Engaged","CountEngagement" , sum(table[Engaged])),
SUMMARIZE(table, "Engagement","Disengaged","CountEngagement" , sum(table[Disengaged])),
SUMMARIZE(table, "Engagement","ActivelyDisengaged","CountEngagement" , sum(table[ActivelyDisengaged]))
)

Hi aaron797 ,

We can create a Calculated table to store the name of enagement, then we can create a measure to calculate the result of each measure:

Calculated Table:

Engagement = DATATABLE("Engagement",STRING,{{"Engaged"},{"Disengaged"},{"Actively Disengaged"}})

Measures:

CountEngagement = SWITCH(SELECTEDVALUE(Engagement[Engagement]),"Engaged",[Engaged],"Disengaged",[Disengaged],"Actively Disengaged",[ActivelyDisengaged])

Best regards,