Forum Discussion
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
- amustafaSolution Sage
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_KayaniFrequent Visitor
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