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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

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
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

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