Forum Discussion

Belindah's avatar
Belindah
Frequent Visitor
1 year ago
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...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    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. 

parry2k's avatar
parry2k
Super User
1 year ago

Belindah what is the expression of following measures:

 

[Combined SLA Met Percentage by Team Domiciled]

[Combined SLA Met Percentage by Team Non-Domiciled]

Belindah's avatar
Belindah
Frequent Visitor
1 year ago
Combined SLA Met Percentage by Team Domiciled =
CALCULATE(
    DIVIDE(
        SUMX(CombinedTicketsDomiciled, CombinedTicketsDomiciled[SLA Met]),
        COUNTROWS(CombinedTicketsDomiciled),
        0
    ) * 100,
    ALLEXCEPT(CombinedTicketsDomiciled, CombinedTicketsDomiciled[Team])
)
and
Combined SLA Met Percentage by Team Non-Domiciled =
CALCULATE(
    DIVIDE(
        SUMX(CombinedTicketsNonDomiciled, CombinedTicketsNonDomiciled[SLA Met]),
        COUNTROWS(CombinedTicketsNonDomiciled),
        0
    ) * 100,
    ALLEXCEPT(CombinedTicketsNonDomiciled, CombinedTicketsNonDomiciled[Team])
)
Those measures work correctly, but I can't get the other table to pull the individual values.