Forum Discussion
AlexanderNN
2 years agoFrequent Visitor
Change measure default behavior with calculation groups
Hey guys, I just got a request to change the default behavior of all our measures in Power Bi and was wondering if any of you have any good tips before I start breaking everything 😅 We have a...
- 2 years ago
There's nothing I'm aware of that would do this. I think the solution is to change the reports.
datadatadatadat
1 year agoMicrosoft Employee
Calculation groups have recently been extended to support default selections. Take a look at the 'noSelectionExpression' here Calculation groups in Analysis Services tabular models | Microsoft Learn.
Simply paste the expression for 'OnlyGroupSales' into the noSelectionExpression, and it should apply to every measure reference without end users making any calc item selections.
Note that you have to use tabular editor to author these artifacts.