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
