Show Value on selected value in Column

Hello Sriku,

Thank you for reaching out to the Microsoft Power BI Community.

Based on your query, you wanted to calculate the average of the Amt column for a selected Group and Ticket combination. You've now successfully implemented the measure using the following DAX expression:
Selected Group Avg Amt =

CALCULATE(

    AVERAGE(Sheet1[Amt]),

    FILTER(

        Sheet1,

        Sheet1[Group] IN VALUES(Sheet1[Group])

    )

)

To allow users to interact with the data, add a slicer for the Group column (A, B, C, D). This slicer will filter the data based on the selected group, affecting the Selected Group Avg Amt measure. Then, add a table visual with the Ticket field to categorize rows and display the Selected Group Avg Amt to show the average amount for each ticket, based on the group selection. This enables dynamic insights into how Amt values vary by ticket and group.

Additionally, I have included the PBIX file that I created using the provided sample data. Kindly review it and confirm whether it aligns with your expectations.

If this solution worked for you, kindly mark it as Accept as Solution and feel free to give a Kudos, it would be much appreciated!

Thank you.