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 |
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
84 | |
83 | |
64 | |
60 | |
55 |
User | Count |
---|---|
183 | |
111 | |
105 | |
77 | |
70 |