Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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 |
---|---|
83 | |
70 | |
69 | |
66 | |
53 |
User | Count |
---|---|
94 | |
92 | |
91 | |
77 | |
70 |