DAX: Default Member

verscev

New Member
Joined
May 10, 2017
Messages
1
All,


We have 3 different kinds of M2 calculations: Bruto, Netto and SuperNetto.

To make the calculation intelligent, we made one M2 calculation which uses the Netto M2 as a default.
In parallel we have a member (Calculation Type) which contain all the M2 kinds (Bruto, Netto and SuperNetto).


This works great when the Calculation Type is not used, even the totals are shown perfectly!


When I do select the Calculation Type, it still shows the correct values, except for the Totals/Grand Totals. Within this context, no Calculation Type is active, and therefore, it falls in my default loop (=Netto).


Instead of the default calculation, I would like to show BLANK(), because a summation of Netto, Bruto and SuperNetto does not mean anything.


Is there a way that I can achieve this?


This is my DAX formula:

M2 (Ordered):=
VAR DefaultMeasureType =
CALCULATE (
VALUES ( 'Measure Type'[Calculation Type] );
'Measure Type'[Default] = "X"
)
RETURN
IF (
HASONEVALUE ( 'Measure Type'[Calculation Type] );
SWITCH (
VALUES ( 'Measure Type'[Calculation Type] );
"Bruto"; SUM ( 'Orders'[_BrutoM2] );
"Netto"; SUM ( 'Orders'[_NettoM2] );
"SuperNetto"; SUM ( 'Orders'[_SuperNettoM2] )
);
IF (
NOT ( ISFILTERED ( 'Measure Type'[Calculation Type] ) );
SWITCH (
DefaultMeasureType;
"Bruto"; SUM ( 'Orders'[_BrutoM2] );
"Netto"; SUM ( 'Orders'[_NettoM2] );
"SuperNetto"; SUM ( 'Orders'[_SuperNettoM2] )
);
BLANK ()
)
)


Kind regards,
Evi Verschueren
 

Forum statistics

Threads
1,084,859
Messages
5,380,326
Members
401,665
Latest member
iahmad

Some videos you may like

This Week's Hot Topics

Top