Need Help - DAX Code

In your picture, in the results table, the first row has empty Parent Ticket, though you want to see 586?

This is in contrast with your definition:

• If the Parent Ticket is blank, the Relevant hrs should be blank.

Please clarify and resend the result you want

If this helped, please consider giving kudos and mark as a solution

me in replies or I'll lose your thread

Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page

Consider voting this Power BI idea

Francesco Bergamaschi

MBA, M.Eng, M.Econ, Professor of BI

FBergamaschi 

many different parent ticket is not possible, one parent ticket only for one ticket

Hi itsranga please try this measure

Relevant Hrs Measure =

VAR ThisTicket = SELECTEDVALUE('Sheet6'[Ticket No])

VAR IsParent = ISBLANK(SELECTEDVALUE('Sheet6'[Parent Ticket]))

RETURN

IF (

    IsParent,

    CALCULATE (

        SUM ( 'Sheet6'[Total Hrs] ),

        FILTER (

            ALL('sheet6'),

            'Sheet6'[Parent Ticket] = ThisTicket

                || 'Sheet6'[Ticket No] = ThisTicket

        )

    )

)

 

 

Hi itsranga ,

Thanks for sharing the detailed process you’ve explained it quite well, and your approach is absolutely correct. Just to confirm, once you load your data into Power BI from Excel or your relevant source, you can go ahead and create the "Relevant Hrs" calculated column in the Data view.
The DAX expression you've mentioned works fine  it checks if the Parent Ticket is not blank and then uses CALCULATE with ALLEXCEPT to sum the Total Hrs grouped by Parent Ticket. If the Parent Ticket is blank, it rightly returns a blank value. After that, adding the fields like Ticket No, Summary, Parent Ticket, Total Hrs, and the newly created Relevant Hrs into a Table visual in Report view is the right way to go.
Based on your example, if multiple rows share the same Parent Ticket, the Relevant Hrs should show the correct total, like 586 for the Data Conversion case, while entries without a Parent Ticket (like Hourly Conversion) will show blank, which is expected. You can also apply conditional formatting or adjust the column widths to improve readability. Once everything looks good, saving the report and publishing it to the Power BI Service is the final step.
Please feel free to text me back if you have any questions
I’ve attached the .pbix file and screen shorts used in this test for your reference.

Thank you.
Tejaswi.