Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
BenGi
Frequent Visitor

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

BenGi_0-1681748062088.png

 

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:

BenGi_1-1681748268308.png 
instead of

BenGi_2-1681748359513.png

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

 

1 ACCEPTED SOLUTION
BenGi
Frequent Visitor

I finally found a solution in the calulation group :

BenGi_0-1681834619707.png

 

View solution in original post

3 REPLIES 3
BenGi
Frequent Visitor

I finally found a solution in the calulation group :

BenGi_0-1681834619707.png

 

BenGi
Frequent Visitor

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 

Mahesh0016
Super User
Super User

@BenGi 'Rendez-vous de service' table  use in selectedmeasure() or not.

 

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.