Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Is it possible to set the group by column in a SUMMARIZE or SUMMARIZECOLUMNS statement?
The basis statement is
EVALUATE
SUMMARIZECOLUMNS(
'Product Category'[Category];
'Product Subcategory'[Subcategory];
'Product'[Product Name];
"Total Sales Amount"; [Sales Amount]
)
Now I want tot select the group by column by variable (SSRS parameter)
DEFINE
VAR Choose = "Product" // Select GroupBy columns
EVALUATE
SUMMARIZECOLUMNS (
SWITCH (
TRUE ();
Choose = "Category"; 'Product Category'[Category];
Choose = "Subcategory"; 'Product Subcategory'[Subcategory];
Choose = "Product"; 'Product'[Product Name]
);
"Total Sales Amount"; [Sales Amount]
)
I've tried several routes (also with TREATAS(), VALUES(), etc.) but without any succes. I also want to avoid creating an SSRS expression in the SSRS dataset.
Any ideas?
Regards Arne
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
41 | |
19 | |
19 | |
15 | |
15 |
User | Count |
---|---|
49 | |
26 | |
22 | |
17 | |
16 |