Forum Discussion
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
VAR DefaultValue=0 VAR Nb = SELECTEDMEASURE() RETURN if(ISBLANK(Nb),DefaultValue,Nb)
It allows me to display a default value instead of "blank".
Everything is OK in the report associated to this datamodel.
I created a composite model on this datamodel and added a table named" Rendez-vous de service" linked to my table "Ordre_Exécution" from the original datamodel
and I experienced the following problem : when i filter my page on a field of the new table and when my selectedmesure returns a blank, the card encounters a problem:
instead of
If I create the calculation group in the report based on composite model, there is no problem.
Do you understand why I have his problem and have you a solution to fix it ?
Thank you
Benjamin
3 Replies
Anonymous 'Rendez-vous de service' table use in selectedmeasure() or not.
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
