Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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
Solved! Go to Solution.
I finally found a solution in the calulation group :
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
2/ the problem occurs only when default value is "-" but works with "0" value
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
Check out the November 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 19 | |
| 10 | |
| 9 | |
| 4 | |
| 4 |
| User | Count |
|---|---|
| 34 | |
| 32 | |
| 20 | |
| 12 | |
| 11 |