Forum Discussion

itsranga's avatar
itsranga
Helper I
9 months ago
Solved

DAX Query Not working

Need to calculate  Parent ticket and child ticket hrs using DAX formula attached image for my requirement i tried multiple ways but its not working  
Need Help
Show and Tell
  • rohit1991's avatar
    rohit1991
    9 months ago

    Hi itsranga 

     

    1. Create Measures:

    Parent_Hrs = SUM(ParentTickets[TotalHrs])
    Child_Hrs = SUM(ChildTickets[TotalHrs])
    Total_By_Ticket =
VAR _Parent =
    CALCULATE(
        SUM(ParentTickets[TotalHrs]),
        TREATAS(VALUES(ParentTickets[ParentTicketID]), ParentTickets[ParentTicketID])
    )
VAR _Child =
    CALCULATE(
        SUM(ChildTickets[TotalHrs]),
        TREATAS(VALUES(ParentTickets[ParentTicketID]), ChildTickets[ParentTicketID])
    )
RETURN
_Parent + _Child

     

    2. Outcome:

     

rohit1991's avatar
rohit1991
Super User
9 months ago

Hi itsranga 

 

1. Create Measures:

Parent_Hrs = SUM(ParentTickets[TotalHrs])
Child_Hrs = SUM(ChildTickets[TotalHrs])
Total_By_Ticket =
VAR _Parent =
    CALCULATE(
        SUM(ParentTickets[TotalHrs]),
        TREATAS(VALUES(ParentTickets[ParentTicketID]), ParentTickets[ParentTicketID])
    )
VAR _Child =
    CALCULATE(
        SUM(ChildTickets[TotalHrs]),
        TREATAS(VALUES(ParentTickets[ParentTicketID]), ChildTickets[ParentTicketID])
    )
RETURN
_Parent + _Child

 

2. Outcome: