topic Change measure default behavior with calculation groups in DAX Commands and Tips

Change measure default behavior with calculation groups

AlexanderNN — Thu, 16 May 2024 06:55:48 GMT

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 central semantic model for our Sales data. What I want to to is alter the dafult calculations for a lot of measures. This is a a very simple measure which calculates our Order Inflow:

CALCULATE( SUM( 'Fact Order'[OrderinflowAmount] ), 'Fact Order'[IsCancelled] = 0 )

We've recently acquired some companies and have mapped their historical sales to our channels (which is different websites) and I did this Calculation Group to alter the behavior of measures.

OnlyGroupSales: = CALCULATE( SELECTEDMEASURE( ), 'Dim Order Source'[Channel] <> "OLD" ) AllSales : CALCULATE( SELECTEDMEASURE( ) )

The request is now to have the "OnlyGroupSales" as the default calculations for our measures. There are roughly 50 measures that I want to change the default behaviorof. I also want to have the ability to switch between the "AllSales" behavior and "OnlyGroupSales" behavior.

Is this possible using calculation groups or do I have to change all individual measures and create a new calculation group that does the inverse of my OnlyGroupSales? I thought this would be an easy fix, but perhaps it is not possible. Any suggestions would be greatly appreciated 🙂

Re: Change measure default behavior with calculation groups

mark_endicott — Thu, 16 May 2024 08:58:09 GMT

If "OnlyGroupSales" and "AllSales" are calculation items within the same Calculation Group, then you can use a slicer or the filter pane to select "OnlyGroupSales" as the default, by having this selected when you share/publish the report, and users will be able to switch to the AllSales by using the filter.

Sorry if I'm missing something and oversimplifying.

Re: Change measure default behavior with calculation groups

AlexanderNN — Thu, 16 May 2024 10:59:51 GMT

Based on the description you aren't missing something. However, this model has around 10 reports tied to it and I am curious if it is possible to change the default behavior in the model instead of having to edit all reports.

So your solution is the fallback solution if there's no other way.

Re: Change measure default behavior with calculation groups

mark_endicott — Thu, 16 May 2024 12:01:07 GMT

There's nothing I'm aware of that would do this. I think the solution is to change the reports.

Re: Change measure default behavior with calculation groups

datadatadatadat — Wed, 27 Nov 2024 02:32:07 GMT

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.