Forum Discussion
Combining values from 2 tables to display only certain values
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.
Here is a link to the test file I created. I created 3 matrix visuals. The first one shows domiciled SLA percentages per team, the second shows non-domiciled SLA percentages per team, and the last one is the TeamSLAType percentages. That is the one I am having difficulty with. It is showing an average instead of extracting the individual numbers from the other 2 tables (CombinedTicketsDomiciled and CombinedTicketsNonDomiciled). Test SLA.pbix
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!