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 = VAL...
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.
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 |