Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
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.
Proud to be a Super User!
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 |
User | Count |
---|---|
106 | |
86 | |
81 | |
73 | |
72 |
User | Count |
---|---|
112 | |
100 | |
98 | |
72 | |
66 |