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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

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
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

June 2025 community update carousel

Fabric Community Update - June 2025

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