Forum Discussion
Solved
Combining values from 2 tables to display only certain values
I have 2 tables that are calculating SLA totals based on domiciled and non-domiciled locations. The calculations work perfectly. The problem I am having is that I need to show the values by team in o...
Hi Belindah ,
We can create two measures.
Measure = VAR SLAType = SELECTEDVALUE(TeamSLAType[SLA Type]) var _table1=SUMMARIZE(ALLSELECTED('CombinedTicketsDomiciled'),[Team],"value1",[Combined SLA Met Percentage by Team Domiciled]) var _table2=SUMMARIZE(ALLSELECTED('CombinedTicketsNonDomiciled'),[Team],"value2",[Combined SLA Met Percentage by Team Non-Domiciled]) RETURN SWITCH( TRUE(), SLAType = "Domiciled", MAXX(FILTER(_table1,[Team] in VALUES('TeamSLAType'[Team])),[value1]), SLAType = "Non-Domiciled", MAXX(FILTER(_table2,[Team] in VALUES('TeamSLAType'[Team])),[value2]), BLANK() // Handle cases where SLA Type is not matched )Measure 2 = SUMX(VALUES('TeamSLAType'[Team]),[Measure])Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Belindah ,
We can create two measures.
Measure =
VAR SLAType = SELECTEDVALUE(TeamSLAType[SLA Type])
var _table1=SUMMARIZE(ALLSELECTED('CombinedTicketsDomiciled'),[Team],"value1",[Combined SLA Met Percentage by Team Domiciled])
var _table2=SUMMARIZE(ALLSELECTED('CombinedTicketsNonDomiciled'),[Team],"value2",[Combined SLA Met Percentage by Team Non-Domiciled])
RETURN
SWITCH(
TRUE(),
SLAType = "Domiciled", MAXX(FILTER(_table1,[Team] in VALUES('TeamSLAType'[Team])),[value1]),
SLAType = "Non-Domiciled", MAXX(FILTER(_table2,[Team] in VALUES('TeamSLAType'[Team])),[value2]),
BLANK() // Handle cases where SLA Type is not matched
)Measure 2 = SUMX(VALUES('TeamSLAType'[Team]),[Measure])
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
That worked. Thank you so much!