Forum Discussion

Wajahat_Kayani's avatar
Wajahat_Kayani
Frequent Visitor
2 years ago

Creating report using single Dax

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 

2 Replies

    • Wajahat_Kayani's avatar
      Wajahat_Kayani
      Frequent Visitor

      Thanks amustafa ,

       According to my knowledge Calculation Groups work with single dimension like 

      CategoryTotal SalesAverage Sales
      abc 5025

       

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

      CategorySub-CategoryProductTotal Sales Average Sales
      Furnitureofficelma4522.5
      abcpqrxyz5025