met/unmet data table

[Anonymous]

Hello Team,

Need help to setup guage dasboard . The criteria as follows. I have 2 table - Table1 & Table2

Table1

Table2

WRT ticket type, priority and target time from table1 --> the data should met/unmet from table2.

[dedelman_clng]

Hi @Anonymous  - you need to provide more information on what you are attempting to accomplish.

- What is "Custom" on Table 2?

- What defines met and unmet?

- Are you attempting to do this in PowerQuery/M, or with DAX?

- What kind of visuals are you hoping to use with this data?

Also, please put data in a format that can be copied, or provide a link to you pbix file. Refer to this link for other tips: How to Get Your Question Answered Quickly 

David

[Anonymous]

- What is "Custom" on Table 2?

It's time format in h:nn:ss

- What defines met and unmet?

If table1 target time is <= custom in table2 with respect to ticket type from both table1 & table2 then its MET 

- Are you attempting to do this in PowerQuery/M, or with DAX?

With DAX

- What kind of visuals are you hoping to use with this data?

Having plan to put filter with Met/UnMet  or with Guage % value

[dedelman_clng · Accepted solution]

- What is "Custom" on Table 2?

It's time format in h:nn:ss

I guess I'll have to assume that is the time to ticket resolution (1st ticket on the list was resolved in 28 seconds, etc). Given that assumption, use a calculated column

Met =
VAR __AllowedTime =
    LOOKUPVALUE (
        Table1[Target Time],
        Table1[Ticket Type], Table2[Ticket Type],
        Table1[Priority], Table2[Priority]
    )
RETURN
    IF ( Table2[Custom] < __AllowedTime, "Met", "Unmet" )

If this doesn't work, please share your pbix file, or share some data in a format that can be copied.

Hope this helps

David