Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Problem Calculation Group displaying default value "-" instead of blank in composite model

Hi all, I am using in a data model a calculation group with 2 items :  Item 1 blank > - VAR DefaultValue="-" VAR Nb = SELECTEDMEASURE() RETURN if(ISBLANK(Nb),DefaultValue,Nb)  Item 2 blank > 0 ...
  • Anonymous's avatar
    Anonymous
    3 years ago

    I finally found a solution in the calulation group :

     

Anonymous's avatar
Anonymous
Not applicable
3 years ago

no the selectedmeasure is created in the "first" data model.
I did few other tests.

1/ if I create a measure in the first datamode without using calculation group > same problem

TxReal =
VAR DefaultValue="-"
VAR Nb = DIVIDE (
0+'Indicateurs'[Nb_PS_Realises_Planifies_Periode],
'Indicateurs'[Nb_PS_Planifies_Periode]
)
RETURN if(ISBLANK(Nb),DefaultValue,Nb)

2/ the problem occurs only when default value is "-" but works with "0" value