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.
Hi Belindah ,
I'm sorry I can't understand your needs, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. Thank you.
Refer to:
How to provide sample data in the Power BI Forum
How to Get Your Question Answered Quickly
Best Regards,
Neeko Tang
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!