Creating report using single Dax

[Wajahat_Kayani]

I want to create a report using single dax.

In dax i used different variablies like  

VAR category = VALUES(Orders[Category])

VAR sub_category = VALUES(Orders(sub-category])

VAR products = VALUES(Orders[Products])

VAR total_sales = SUMX(Orders , Orders[Sales])

VAR avg_sales = AVERAGEX(Ordres , Orders[Sales])

VAR result = ???? (I want to add all these VAR in result to show as report)

RETURN result 

[amustafa]

Are you talking about Calculation Groups?

See this video as an example: How to set up and use Calculation Groups in DAX | Power BI (youtube.com)

Can you privide a sample input and output in text format so it's easier to understand your requiremnts.

[Wajahat_Kayani]

Thanks @amustafa ,

 According to my knowledge Calculation Groups work with single dimension like 

Category	Total Sales	Average Sales
abc	50	25

I am tring to create a report using single dax my expected result is :

Category	Sub-Category	Product	Total Sales	Average Sales
Furniture	office	lma	45	22.5
abc	pqr	xyz	50	25